| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please Help! Cells not updating... | Excel Discussion (Misc queries) | |||
| Updating Cells with new info | Excel Discussion (Misc queries) | |||
| Automatically updating cells in a different tab? Possible? | Excel Worksheet Functions | |||
| Have a Macro run after updating cells | Excel Discussion (Misc queries) | |||
| Cells not updating | Excel Worksheet Functions | |||
Linear Mode
