Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Big delay to recalculate formulas
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Big delay to recalculate formulas
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 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif formulas change after doing a sort | Excel Worksheet Functions | |||
copy worksheet to a new workbook with formulas .... but new file not point to old one | Excel Discussion (Misc queries) | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Problem with named formula's | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |