Sometimes when if reference a value in another worksheet I get an absolute
value displayed. For instance I would type = then go to the sheet where I
wanted to pull the information from, say a work sheet named "Oxen", select
the cell I want and hit the enter key. What I get in the cell is
'=Oxen!C457' or something like this. But the value in Oxen, C457 is 12.56.
What is the problem? This happens on a random basis and it is driving me
nuts. There must be a togle somewhere that needs to be set or reset or
whatever.

Hi,

ToolsOptionsViewensure Formulas is unchecked

Tim


"Laska" wrote:

Sometimes when if reference a value in another worksheet I get an absolute
value displayed. For instance I would type = then go to the sheet where I
wanted to pull the information from, say a work sheet named "Oxen", select
the cell I want and hit the enter key. What I get in the cell is
'=Oxen!C457' or something like this. But the value in Oxen, C457 is 12.56.
What is the problem? This happens on a random basis and it is driving me
nuts. There must be a togle somewhere that needs to be set or reset or
whatever.