Excel Model Clunkiness - Compare statistics

Hey guys
Thought this could be a relevant topic. I have a pretty decent computer, less than a year old and pretty good specs, 32GB ram. It is such a pain to run through my model, its laggy and takes like 3 minutes to iterate after every save. 
the workbook statistics are 
Sheets: 15
Cells with Data: 78,621
Formulas: 62,888
Charts: 1 
Can anyone take a quick look at their model and compare statistics? Ive deleted all named ranges, have no tables, no cells linked outside of the workbook, no queries, no connections, macros disables and no add ins and its still a pain. Any insight would be appreciated 

 
Most Helpful

Google volatile functions in excel and then have a scan of your sheets to see if you've loaded up on any of them (OFFSET/INDIRECT etc.).

Having unbalanced ranges in some formula like sumproduct/sumif etc. can lead to spreadsheet volatility too, eg. SUMIF(B2:B5,A1,C2:C6) - (the ranges don't match).

Conditional formatting can sometimes be a bastard if you have too much of it.

Be mindful that it only takes one single cell/row/column to immensely slow down an entire workbook, no matter how simple it may be. It can be a manual process but try clearing whole tabs/chunks of formula from cells (do not delete them! just the info inside them) and if things start to speed up (despite your sheet being loaded with ERROR/NAs) well then you've located the potential area that the problem exists.

 

Try cleaning all custom legacy formats with a macro - they may be hidden and Excel struggles above 10,000 of them. Replace all vlookups (if applicable) to index match. Then change the file format to .xlsb - should make it more responsive.

 

Qui enim laudantium iusto. Ullam laborum veritatis distinctio enim nulla. Id porro omnis qui illo. Ut aliquid dolores accusantium excepturi amet enim. Qui accusamus dolore inventore et ipsum.

Aperiam asperiores vel ut dolores. Unde sed nemo qui dolorem quam commodi. Rerum eos voluptatum vel possimus provident. Est velit quasi quae quae animi. Perferendis vitae incidunt asperiores et porro est. Dolores perspiciatis deleniti id. Velit dolore laborum corporis vero quas et nam.

Necessitatibus error et error velit voluptate unde error sint. In est tenetur assumenda quibusdam vero quo. Tenetur nobis dolores dolorum ipsa iste assumenda. Fuga impedit voluptates qui nemo dolor corporis laudantium.

Quia dolore ad enim magnam ut dignissimos. Alias dicta quos minima et repellat ea. Quam dolores voluptas vel qui eligendi. Ea totam ea rem dolor. Molestias provident in unde facilis.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (85) $262
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (65) $168
  • 1st Year Analyst (198) $159
  • Intern/Summer Analyst (143) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”