"CALCULATE" appearing on bottom tool bar

Murray D. · Apr 11th, 2002, 08:39 AM

Have I a large spreadsheet (+/- 12mb) with a number of VLOOKUP and SUMIF formulas in it. The problem I have is that if I add any more formulas the "CALCULATE" message appears in the bottom toolbar. If I push F9 it recalculates but the "CALCULATE" message still appears. I have tried "CTRL+ALT+F9" but this still does not help. If I shut down and restart the error is still there. I am using Excel 97 with SR2 patch.

Dexter · Apr 11th, 2002, 08:43 AM

Go to the TOOLS menu, select Options and then click the CALCULATION tab. The setting is probably on MANUAL. Set to AUTOMATIC.

Murray D. · Apr 11th, 2002, 08:49 AM

I wish it were that simple. Calculation is already set to automatic. If I force a recalc by pushing F9 it says "Recalulating" and the percentage appears, but when it is finished the "Calculate" still appears.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 08:39 AM	#1
Murray D. New Member Join Date: Apr 2002 Location: Durban, South Africa Posts: 3	Have I a large spreadsheet (+/- 12mb) with a number of VLOOKUP and SUMIF formulas in it. The problem I have is that if I add any more formulas the "CALCULATE" message appears in the bottom toolbar. If I push F9 it recalculates but the "CALCULATE" message still appears. I have tried "CTRL+ALT+F9" but this still does not help. If I shut down and restart the error is still there. I am using Excel 97 with SR2 patch.

Apr 11th, 2002, 08:43 AM	#2
Dexter Board Regular Join Date: Apr 2002 Location: St. Louis Posts: 71	Go to the TOOLS menu, select Options and then click the CALCULATION tab. The setting is probably on MANUAL. Set to AUTOMATIC.

Apr 11th, 2002, 08:49 AM	#3
Murray D. New Member Join Date: Apr 2002 Location: Durban, South Africa Posts: 3	I wish it were that simple. Calculation is already set to automatic. If I force a recalc by pushing F9 it says "Recalulating" and the percentage appears, but when it is finished the "Calculate" still appears.