Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Formula not responding
All of a sudden, worksheets with formulas that I have been using forever are
not responding to changes in data. I checked formulas and formatting - all is correct. The cell with the formula in it does not show a changed result when the related data changes.....Seems suddenly to have happened to all my spreadsheets! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Formula not responding
Under Tools Option check the Calculation settings..
Set that to automatic if not -- If this post helps click Yes --------------- Jacob Skaria "Formulas not responding to changed data" wrote: All of a sudden, worksheets with formulas that I have been using forever are not responding to changes in data. I checked formulas and formatting - all is correct. The cell with the formula in it does not show a changed result when the related data changes.....Seems suddenly to have happened to all my spreadsheets! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Formula not responding
Tools - Options - Calculation
Make sure Automatic is selected. "Formulas not responding to changed data" wrote: All of a sudden, worksheets with formulas that I have been using forever are not responding to changes in data. I checked formulas and formatting - all is correct. The cell with the formula in it does not show a changed result when the related data changes.....Seems suddenly to have happened to all my spreadsheets! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time/Custom formula and formats not responding | Excel Discussion (Misc queries) | |||
Not Responding Excel 2003 during print preview | Setting up and Configuration of Excel | |||
Excel 2003 not responding to "X" to close program | Excel Discussion (Misc queries) | |||
windows excel &word 2003 pro save as command not responding | Excel Discussion (Misc queries) | |||
Excel 2003 - insert picture - Not Responding | Setting up and Configuration of Excel |