My folumlas are not picking up the correct cell.

[Blackhawk]

My workbook is set to auto calculate. On sheet A, my formula is the value in
cell g19 in sheet B. The formula returns the value in cell G13 on sheet B.
I retype the formula and it picks it up correctly.

My workbook is very large and I have multiple cells to check. It is not
practicle to reenter every formula. Also, the problem is not corrected by
hitting the calculate now button under tools/options/calculate.. I have 2
meg of memory.

 

[Nick Hodge]

Try Edit>Replace and replace = with =

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

(e-mail address removed)
www.nickhodge.co.uk