Excel refernce to another worksheet

Closed
Kit - Oct 15, 2010 at 12:04 PM
sharpman
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
- Oct 15, 2010 at 12:20 PM
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

sharpman
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
183
Oct 15, 2010 at 12:20 PM
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.
0