Excel 2007 : Reference returns cell address - not data

**Martin Snerl** · 01-14-2010, 05:41 AM

In the following case of references between worksheets, the formatting from the original cell does not appear in the cell that it is referenced to.
Worksheet 3, A1 contains an apartment # - e.g. 4
Worksheet 4, A1 references this cell but returns the cell address - Worksheet2,!A1' - rather than the number 4.
I tried different formats for the number 4, including =TEXT, but it did not correct the problem.
Thank you

**Andy Pope** · 01-14-2010, 06:38 AM

Does the worksheet 4 A1 display,

=Worksheet2!A1

In which case you have Window options > Formulas, enabled.

Select worksheet 4 and use Tools > Options > View > Window Options > Formula.