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.

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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"VishalBade" wrote:
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.