Linking cells to another tab in workbook

[krcherrey]

I am linking cells to another tab in my workbook. The formula has been working fine until suddently today when I try to link the cell instead of showing the cell content it is showing the cell formula. for example:

cell A1 I type =Master!A21
previously cell A1 would show : 2.2 (which is the content of cell A21 on Master tab)
Now A1 is showing the formula =Master!A21

How can I fix this?

 

[Weazel]

what happens if you press Control + ~ ?

 

[krcherrey]

what happens if you press Control + ~ ?

The entire spread sheet shows formalas instead of content, and when I click again it goes back to some showing the content of the cell and some showing the formula. It is giving me an error showing Inconsitence Calculated Column Formula...