formula is displayed instead of the result

V

VishalBade

I clear a cell by going to edit menu, clear all.
write a simple formula such as ='SI Data work'!B2, this works fine and shows
the value.

now if I go and change B2 to C2 in the formul, it does not work, if shows
the formula as string.
I have a lot of formulas in a row and this is making me retype each and
every formula.

Thanks in Advance.
 
M

Max

Try these checks ..

1. Check calc mode is set to auto (Tools > Options > Calculation tab, Check
"Automatic" > OK)

2. Check cell is not formatted as text (Format > Cells). If so, re-format
the cell as General or Number, then re-confirm the formula (click inside the
formula bar, press Enter) -- you need to reconfirm the formula before it'll
work.

3. Check that you're not in formula view (Tools > Options > View tab,
"Formulas" should be unchecked)
 
Top