| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet won't recalculate when numbers are changed.
I'm having trouble with my excell 2003 spreadsheets I have formulas in cells
that use a number to drive calculations in the soread sheet. the only way I can to get the spreadsheet to recalculate is to go to each cell with a formula, double click on it then hit enter for each cell. I know this isn't the way it's supposed to work but I don't know what's wrong or how to fix the problem. I'd appreaciate any suggestions. Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Spreadsheet won't recalculate when numbers are changed.
Make sure calculation is set to automatic...
ToolsOptionsCalculation tabAutomaticOK -- Biff Microsoft Excel MVP "c3peteo" wrote in message ... I'm having trouble with my excell 2003 spreadsheets I have formulas in cells that use a number to drive calculations in the soread sheet. the only way I can to get the spreadsheet to recalculate is to go to each cell with a formula, double click on it then hit enter for each cell. I know this isn't the way it's supposed to work but I don't know what's wrong or how to fix the problem. I'd appreaciate any suggestions. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a function that will email a spreadsheet if changed? | Excel Worksheet Functions | |||
| col of minus numbers changed to plus numbers | Excel Worksheet Functions | |||
| Large Spreadsheet - Freeze On Recalculate | Excel Worksheet Functions | |||
| Why is my spreadsheet not updating changed formulas? | Excel Discussion (Misc queries) | |||
| Data changed in the back-up spreadsheet | Excel Discussion (Misc queries) | |||
Linear Mode
