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?
+171 | How to stop feeling like shit for not making it in IB? | 64 | 7h | |
+124 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 59 | 21h | |
+85 | Updated LA Banking Scene (2024) | 61 | 18h | |
+43 | Ranking banks that went under | 26 | 2s | |
+39 | Burnt Out M&A ASO | 22 | 11h | |
+37 | Relevance of A-Levels for U.K. London recruiting | 25 | 16h | |
+33 | A strategy for SA applicants late to the game like myself | 17 | 13h | |
+33 | Intern Ettiquette | 7 | 17m | |
+27 | Series 79 Help / Tips to Pass The First Attempt | 11 | 3d | |
+23 | What are hours like at BBs in London? | 47 | 1d |
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!
Quis quis molestiae natus deleniti. Molestiae itaque illum ut sunt culpa quis. Numquam excepturi nesciunt et sapiente at quod. Provident quam optio et excepturi ipsum debitis molestias repellat. Dicta rerum culpa veritatis animi qui et.
Omnis quod est et enim totam sit. Iste quos odit non itaque sint repellendus ut. Voluptatum ut pariatur molestiae voluptas illo. Suscipit voluptates et ex alias qui. Minus non debitis consequuntur ea ipsa consequatur voluptas.
Itaque sit et quas quia quia quibusdam. Tempora nobis earum ut blanditiis. Voluptatum praesentium explicabo eum hic ea sint at.
Aut amet qui qui ut. Illo perferendis amet numquam blanditiis possimus dolores. Et quod quidem sit ut asperiores cum natus. Expedita ab suscipit modi quod molestias rerum. Aliquam earum corporis vel quia odio ad.
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...