Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula not updating
I am using very basic formula to calculate sums on a spreadsheet, and usually
it works fine, but for some reason they are no longer updating? Does anyone know why? The formula still seems to be in the cell, but it doesn't change when I amend the numbers above it. Using Excel 2003. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula not updating
Make sure calculation is set to automatic.
ToolsOptionsCalculation tabAutomaticOK -- Biff Microsoft Excel MVP "Katie" wrote in message ... I am using very basic formula to calculate sums on a spreadsheet, and usually it works fine, but for some reason they are no longer updating? Does anyone know why? The formula still seems to be in the cell, but it doesn't change when I amend the numbers above it. Using Excel 2003. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula not updating
Thanks so much! For some reason it had been changed to Manual, and now I have
changed it back to automatic it is working fine again. Thanks again! That was driving me crazy :) "T. Valko" wrote: Make sure calculation is set to automatic. ToolsOptionsCalculation tabAutomaticOK -- Biff Microsoft Excel MVP "Katie" wrote in message ... I am using very basic formula to calculate sums on a spreadsheet, and usually it works fine, but for some reason they are no longer updating? Does anyone know why? The formula still seems to be in the cell, but it doesn't change when I amend the numbers above it. Using Excel 2003. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula not updating
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Katie" wrote in message ... Thanks so much! For some reason it had been changed to Manual, and now I have changed it back to automatic it is working fine again. Thanks again! That was driving me crazy :) "T. Valko" wrote: Make sure calculation is set to automatic. ToolsOptionsCalculation tabAutomaticOK -- Biff Microsoft Excel MVP "Katie" wrote in message ... I am using very basic formula to calculate sums on a spreadsheet, and usually it works fine, but for some reason they are no longer updating? Does anyone know why? The formula still seems to be in the cell, but it doesn't change when I amend the numbers above it. Using Excel 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula not updating | Excel Discussion (Misc queries) | |||
Formula not updating | Excel Discussion (Misc queries) | |||
Updating one cell with a formula | Excel Worksheet Functions | |||
self-updating formula | Excel Discussion (Misc queries) | |||
Formula not updating | Excel Worksheet Functions |