Formulas not automatcially calculating on spreadsheet

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AVERAGE formula with a twist 5
Sum function not calculating? 1
How do I ignore cell values of zero? 2
Formulas not calculating in some fields 1
Summing random cells as you click on them 5
Formulas not calculating automatically 5
Edit / Compute over a large range... 6
formulas are not working on my spreadsheet 2

Top