Cells are not updating
 

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

Cells are not updating
 

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.
--
Cheers,
Shane Devenshire


"Graeme" wrote:

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

Cells are not updating
 

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.

"ShaneDevenshire" wrote:

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.
--
Cheers,
Shane Devenshire


"Graeme" wrote:

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

Cells are not updating
 

Try

Ctrl + Alt + F9


--
Regards,

Peo Sjoblom


"Graeme" wrote in message
...
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.

"ShaneDevenshire" wrote:

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.
--
Cheers,
Shane Devenshire


"Graeme" wrote:

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

Cells are not updating
 

Hi,

You can also try CTRL+ALT+SHIFT+F9, or less drasticallly Shift+F9.

--
Cheers,
Shane Devenshire


"Graeme" wrote:

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