| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulae in spreadsheet no longer update with new data
I have a simple accounting spreadsheet that I've used for months. All of a
sudden, the formulas do not work when I add new data. Spreadsheet still displays the old sums and differences. What has happened that corrupted these spreadsheets. If I start all over again, the new spreadsheet apperas to work fine.. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulae in spreadsheet no longer update with new data
It seems like the calculation is set to Manual:
Try this: ToolsOptionsCalculation tab Check: Automatic calculation Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Stevej47" wrote: I have a simple accounting spreadsheet that I've used for months. All of a sudden, the formulas do not work when I add new data. Spreadsheet still displays the old sums and differences. What has happened that corrupted these spreadsheets. If I start all over again, the new spreadsheet apperas to work fine.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| how do I get data from one excel spreadsheet to another | Excel Discussion (Misc queries) | |||
| Update and add new row of data help? | Excel Worksheet Functions | |||
| Extracting Data from another spreadsheet | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Hybrid Mode
