software

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: www.excelforum.com/member.php...oamp;userid=30381
View this thread: www.excelforum.com/showthread...hreadid=500415For performance problems, visit

www.decisionmodels.com

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

--
Kind regards,

Niek Otten

quot;LACAquot; gt; wrote in message
...
gt;
gt; I am working on a financial model that has hundreds and hundreds of
gt; formulas in it spread over about 25 worksheets which all link back and
gt; forth. The file is 5.34 MG. Every time I change some data, there is
gt; about a 2-3 second wait time for the revised totals to calculate. I
gt; realize that the file is large, and that a lot of formulas take up
gt; memory, but I've got other files that are as just big or even bigger
gt; that contain lots of formulas, and I don't get this delay with them.
gt;
gt; What are some other factors I should look at that would cause such a
gt; calculation delay? I seriously need to fix this or the multiple users
gt; will be miserable!
gt;
gt; Thanks in advance.
gt;
gt;
gt; --
gt; LACA
gt; ------------------------------------------------------------------------
gt; LACA's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30381
gt; View this thread: www.excelforum.com/showthread...hreadid=500415
gt;
Check out the Excel Page on Charles Williams' site for calculation secrets and
optimizing.

www.decisionmodels.com/Gord Dibben MS Excel MVP

On Wed, 11 Jan 2006 16:31:06 -0600, LACA
gt; wrote:

gt;
gt;I am working on a financial model that has hundreds and hundreds of
gt;formulas in it spread over about 25 worksheets which all link back and
gt;forth. The file is 5.34 MG. Every time I change some data, there is
gt;about a 2-3 second wait time for the revised totals to calculate. I
gt;realize that the file is large, and that a lot of formulas take up
gt;memory, but I've got other files that are as just big or even bigger
gt;that contain lots of formulas, and I don't get this delay with them.
gt;
gt;What are some other factors I should look at that would cause such a
gt;calculation delay? I seriously need to fix this or the multiple users
gt;will be miserable!
gt;
gt;Thanks in advance.