Excel refernce to another worksheet [Closed]

Report
-
Posts
1023
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
-
Hello,

When I try to reference a cell in another sheet of the same workbook, I get the formula instead of the value. i.e. +"sheet 2"!G65 displays "+"sheet 2"!G65" instead of the value in G65.

I have never experienced this problem before.

Thank you,

1 reply

Posts
1023
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
243
where you have the + in the formula put a =
this will tell the cell that it equals the contents of the cell in the other sheet.