Hello,
I have a cell (cell A) on one tab referencing a cell on another tab (cell
B), but returning an incorrect value. Is there a way to fix this on a
wholescale level. It was not a calculation problem (tried F9). I was able
to fix the problem by putting the cursor at the end of the formula in cell A
and hitting enter, but this could be happening throughout the spreadsheet.
Any advice or help is greatly appreciated.

Thank you,

John