Formulas not automatcially calculating on spreadsheet

  • Thread starter Thread starter Huppy
  • Start date Start date
H

Huppy

Hi,

I ahve a problem with a spreadsheet that was moved from one folder to
another.

In the cells are numerous formula's referencing values in other
spreadsheets. These values are all (incorrectly) listed as 0.

If you click on the cell and press enter, then the values are then inserted.
Likewise if you manually type in the reference the correct value is also
inserted.

I hope I've explained this well! There are 1000s of these cells so clicking
on each one would be quite a chore.

TIA,

H
 
Back
Top