Model DIV's out when closing out

I know I posted a similar topic the other day, but now the situation has gotten a little stranger... My model is fine, I can refresh, F9, everything without having any issues. I save it down as a new version and have no issues. However, as soon as I click "X" to exit out of Excel, a large portion of the model shows #DIV/0!. Unfortunately my firm's model has macros built into it (and I am not a programmer so I cannot really diagnose if that has something to do with it). I know I can just make sure I save down a new version before exiting every time, I just want to know if anyone else has seen this problem in the past?

Thanks.

 

First, save a backup (for important files, you should always have a backup stored off your machine, on a server). I back up all my work stuff to an external harddrive, a USB, and the internet. Data backup is ultra important.

Then, in your file, try doing some stuff in it, but not saving. Click the X like you're going to exit, and when it asks you to save; save it (again, make sure you have a backup).

When you reopen the saved file, does it have the DIV error?

It's probably some sort of glitch, maybe you have an if function where one of the outputs is zero and that links to other cells and what not. The underworkings of excel can be quite mysterious lol.

 

Sounds like the build-in macros are referencing certain cells that you may have moved around? Did you copy/paste or change the location of any major cells? Try checking a different model and see if everything is in the same spot. Not sure though. My VBA isn't that good either.

 
XPJ:
Sounds like the build-in macros are referencing certain cells that you may have moved around? Did you copy/paste or change the location of any major cells? Try checking a different model and see if everything is in the same spot. Not sure though. My VBA isn't that good either.

This is a common one, that's why you should name references if you're running macros on models that don't have an uber strict format/template.

 

Ea laudantium ab facere alias. Et molestias nemo minus unde harum. Architecto labore aliquam sunt expedita id dicta accusantium. Id iste earum doloremque at inventore.

Ut dolorem et dolore. Deleniti non est sapiente porro suscipit aliquam et ratione. Id provident unde magni corrupti autem. Et harum architecto voluptates ut est qui suscipit quos.

Dolores inventore illo deleniti. Est porro recusandae impedit non voluptatem enim numquam. Eos quae rerum rerum nihil sunt dolore.

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 (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $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

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
dosk17's picture
dosk17
98.9
6
CompBanker's picture
CompBanker
98.9
7
kanon's picture
kanon
98.9
8
GameTheory's picture
GameTheory
98.9
9
DrApeman's picture
DrApeman
98.9
10
Jamoldo's picture
Jamoldo
98.8
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...”