Please Login or Register to view this content.
How can I speed this up ??? it sticks for 3 mins or so..
Please Login or Register to view this content.
How can I speed this up ??? it sticks for 3 mins or so..
I don't think that there is any problem in your code. You must be having a large data to work with and with so many formulas to recalulate it is taking time.
Have one suggestion though. Is your page break view on? If yes switch it off. ( Tools > Options > View > Page Breaks ticked off ).
It must be typo but you may want to make screen updating true at the end.
A V Veerkar
Last edited by shg; 12-28-2007 at 01:25 PM. Reason: deleted quote
I have changed it to true (typo) still takes ages
You go to the trouble of computing the last row through which to apply the formulas, yet the formulas themselves hard-code a 60,000 row range. Is that necessary?
If it's the difference between 60,000 rows and 50,000, it won't make much difference -- but if it's a lot more than that, it would make a significant difference.
Edit: I can't even speculate on what the formulas are doing, but perhaps they only need to account for the rows above or below rather than the entire range?
Last edited by shg; 12-28-2007 at 01:33 PM.
This looks like the same question
http://www.excelforum.com/showthread.php?t=628108
Also, adding all those SUMPRODUCT Formulas will be slow to calculate!
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks