Calculate
Posted by Aaron on January 04, 2002 7:30 AM
Can someone let me know why I have Calculate at the bottom of Excel97? I have a 3Meg Spreadsheet that has many formulas in, and when I hit F9 to Calc, it will calc to a certain %age the Calculate will appear again. Does the mean the Spreadsheet cannot calculate all of the formulas? Any help would be appreciated.
Posted by DonnaW on January 04, 2002 7:59 AM
Tools | Options | Calculation (tab) is set to manual calculation and you have changed a value somewhere in your spreadsheet. To enable automatic calculation, change the option to automatic or press F9 to recalculate.
NOTE: sometimes it is good to have calculation set to manual (e.g., when you have a lot of links or lookups and don't want automatic recalculation every time a value changes).
