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