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! |
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! |
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! |
All times are GMT +1. The time now is 01:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com