
Tips.Net > ExcelTips Home > General > Automatic Recalculation Not Happening
Summary: Excel 97, under certain circumstances, has a problem recalculating worksheets reliably. This tip tells you how to patch that issue using a link to Microsoft's Knowledge Base. (This tip works with Microsoft Excel 97.)
If you are using Excel 97, you may have a problem with recalculating your worksheets and not even know it! Apparently, both Excel 97 and Excel 97 SR1 have problems--under certain conditions--doing complete recalculations of the worksheet. While the problem only crops up in certain situations, it was widespread enough that Microsoft issued a patch for the problem.
You can find more information about this issue, as well as information on how to download the proper patch, in Knowledge Base article Q174868. This can be found at this address:
http://support.microsoft.com/default.aspx?scid=kb;en-us;174868
Tip #2082 applies to Microsoft Excel versions: 97
Save Time! ExcelTips has been published weekly since late 1998. Past issues of ExcelTips are available in convenient ExcelTips archives. Have your own enhanced archive of ExcelTips at your fingertips, available to use at any time!
Check out ExcelTips Archives today!
Thousands of ExcelTips, available for immediate download. Have all the Microsoft Excel info you need, right at your fingertips. (more information...)
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site