Cells are not updating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a multi-tab spreadsheet, and all of a sudden, cells with formulae in
them stopped updating themselves. I looked at
Tools>Options>Calculation>Automatic, and it is selected. F9 doesn't work
either. Any help would be greatly appreciated.
Thanks,
Graeme
 
Hi,

Is this happening to all calculated cells or only some of them? Select one
of the cells and make sure the formulas are still in the cell by looking at
the formula bar.
 
It's only happening in some calculated cells, and all the ones I've
identified so far have a formula from another tab. And the formulas are
still there okay.
 
Try

Ctrl + Alt + F9


--
Regards,

Peo Sjoblom


Graeme said:
It's only happening in some calculated cells, and all the ones I've
identified so far have a formula from another tab. And the formulas are
still there okay.
Click to expand...
 
Back
Top