Resetting manual calculation option

A

Alan

Hi -
I am using XL 2002. I have a huge workbook with piles of macros and VB
procedures. I have set the calculation to 'manual' as everytime the
workbook recalculates, it takes 3-5 minutes to do. So manual is the
setting that would control this, but everytime I reopen the workbook, it
defaults back to automatic calculation. Maddening! Suggestions?

Alan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Workbook causes calculation errors 2
Auto Calculate Keeps Resetting to Manual 2
Quicker calculations -- storing huge equations or cutting and past 2
Manual calculation of calculated items in multiple pivottables 2
Application.Calculation Problems 2
Why doesn't Excel understand what 'Manual' for Calculations? 4
"Calculate" appears in staus bar 2
Workbook performance is too weak 1

Top