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.