View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default Big delay to recalculate formulas

For performance problems, visit

www.decisionmodels.com

Please let us know what (if anything) solved your problem

--
Kind regards,

Niek Otten

"LACA" wrote in message
...

I am working on a financial model that has hundreds and hundreds of
formulas in it spread over about 25 worksheets which all link back and
forth. The file is 5.34 MG. Every time I change some data, there is
about a 2-3 second wait time for the revised totals to calculate. I
realize that the file is large, and that a lot of formulas take up
memory, but I've got other files that are as just big or even bigger
that contain lots of formulas, and I don't get this delay with them.

What are some other factors I should look at that would cause such a
calculation delay? I seriously need to fix this or the multiple users
will be miserable!

Thanks in advance.


--
LACA
------------------------------------------------------------------------
LACA's Profile:
http://www.excelforum.com/member.php...o&userid=30381
View this thread: http://www.excelforum.com/showthread...hreadid=500415