Big delay to recalculate formulas

[LACA]

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.

[Niek Otten]

For performance problems, visit

www.decisionmodels.com

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

--
Kind regards,

Niek Otten

"LACA" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[Gord Dibben]

Check out the Excel Page on Charles Williams' site for calculation secrets and
optimizing.

http://www.decisionmodels.com/


Gord Dibben MS Excel MVP

On Wed, 11 Jan 2006 16:31:06 -0600, LACA
<[email protected]> wrote:

>
>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.