Hello.
I have an excel file that weights ~90MB. When i activate a simple function on 6000 cells (turn values into numbers), it takes about an hour for it to finish.
I have Windows 7 64 bit, excel 2010 32 bit, quad core 2.5GHZ, 4GB RAM, Gforce 560 2GB VRAM (if that's relevant). Any suggestions would be appreciated.
Thanks!
Does your workbook contain any conditional formatting?
I've found in the past that this can S-L-O-W things down greatly....
If I've been of help, please hit the star
- delete -
Last edited by Spencer101; 06-10-2012 at 04:06 AM. Reason: EDIT: Unsure why this got posted twice...
Does it contain volatile functions (OFFSET, TODAY NOW,INDIRECT....)? Unnecessary long ranges ( like A:A) ? lots of VLOOKUPS?
All items has to be recalculated?
If you have data that will be static for future use; you can consider to (copy) paste them in value (instead of formula).
That will also increase the speed of the workbook.
It has no conditional formatting, but lots of index-matches. I just hoped that there were some tweaks that i didn't know about.
Any SUMPRODUCT() functions or array (CSE entered) formulas?
Here is a link regarding volatility: http://www.decisionmodels.com/calcsecretsi.htm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks