One thing you can do is go into Tools:Options:Calculations:Manual. This
would let you control when your sheet recalculates.
Some additional information on how large your data set is, how many records
exist, and how complex your calculations are would help us determine if there
are other things going on.
Almost all my spreadsheets are very large, contain thousands of records, and
many cells involve formulas and lookups. It just seems to take forever to
re-calculate. Whenever I can, I'll turn off the automatic re-calculation, or
I'll be all afternoon waiting.
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.
