Slow Excel Model
I just got handed off a model and its running very slow. Simple tasks such as moving from page to page causes the model to 'stall' for a few seconds. Any advice on how to fix this?
I just got handed off a model and its running very slow. Simple tasks such as moving from page to page causes the model to 'stall' for a few seconds. Any advice on how to fix this?
+242 | My chaotic IB journey | 27 | 8h | |
+211 | MS M&A vs GS HC | 48 | 14h | |
+176 | Ending My Life if I don't get an SA 2025 Offer | 63 | 22h | |
+115 | Anyone live in a different country before? What’s it like? | 43 | 17h | |
+74 | Hazing in the Bullpen. What to do? | 15 | 10h | |
+53 | MD shoved food down my throat. Is this normal? | 16 | 22h | |
+40 | Improving in TMT | 12 | 3s | |
+35 | Basically necessary to be a varsity athlete to get BB IB from Bowdoin? | 22 | 1d | |
+35 | Later Chodes - I'm Taking My Talents to The Mega Fund Leagues | 10 | 3s | |
+19 | Too late to be Analyst 1 with 5 years of experience? | 16 | 2d |
Career Resources
Does it have datatables in it?
If so, make sure to turn off the auto compute for data tables.
http://office.microsoft.com/en-us/excel/HP100726561033.aspx#speed
Go to the bottom of the page
Did that work?
Thanks, that was the first thing I did. Have it selected as 'calculate except data tables'
Funny thing is that its not a very large or complex model. Just 4 segment P&Ls, segment BS, CFS and a credit statistics page, but all on different pages
You can turn calculations off
Try this: delete all empty columns off the right edge of each page, and all empty rows off the bottom of the page. Check everything that's left for conditional formatting.
I once had a model that was ballooning in size (>100MB) and running very slowly due to some weird conditional formatting going on in the empty cells.
make sure no funny or busted macros are running in your model.
You could also have an overload of named ranges, etc.
If you have Excel 2007:
Hope this helps!
Et voluptatem sapiente quia quidem qui. Sequi officia rem voluptatem sint alias libero velit aperiam. Velit aut ea beatae tenetur ratione qui.
Iste ipsam perferendis optio nihil consequatur ullam distinctio. Enim quam consectetur aliquam facilis placeat deserunt.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...