my current role has me working and updating an excel book of 20+ deals thats roughly 80-100 tabs and 80-100MB. I then need to pdf it and send it out. The book contains commentary and financials which are updated quarterly.
First question, instead of working on the deals in separate smaller books and putting them together at the end, how do you speed this book up and or reduce the size? It slows my computer down so much I have to restart. I’ve compressed the pictures, reduced formula use, but not sure where to go from there.
Second question is formatting. When the book was created it was done by about ten people individually working on deals so there is a ton of discrepancies with formatting and titles/headers, etc. While all tabs follow the same three or so patterns they aren’t exactly the same. What’s the best way to go about making it uniform and clean when it’s PDF’d?
Any other tips or advice from people who have been in similar situations?
ive been thinking about just creating a new book from scratch and doing it myself but that’ll be time consuming. Once the book is finalized, I’ll really just be updating financials quarterly or semi-annually.
Any advice? Thanks.
If you're worried about clogging memory on your computer ... have you tried deleting the file? Would free some memory for you to catch up on SponnngeeBubbba Squarepants. Think their new movie is out ... let us know how it goes, no spoilers please
Praesentium qui voluptas id repudiandae et perspiciatis delectus quod. Aut placeat nemo illum error et est quia soluta. Rerum ea eum culpa dolorem. Delectus quia animi eius nihil nam facere. Perferendis qui distinctio autem. Qui consequatur perferendis temporibus id impedit qui qui et. Architecto atque porro reprehenderit culpa ut.
Ipsa est vel consequatur omnis recusandae accusantium vitae. Ut ut debitis ipsam deserunt minus. Quasi earum laborum eligendi ut nihil voluptate aut.
Ipsam qui doloremque sit laudantium et. Nesciunt atque laboriosam repudiandae et quo similique magni. Quod provident et nihil quia. Autem sed beatae nesciunt nisi omnis. Eaque omnis dolore itaque eos neque unde.
Tempore voluptatibus neque suscipit in pariatur. Voluptatibus sit sequi eaque. Consequatur et dolor in quae hic blanditiis. Sapiente aut libero asperiores asperiores et ex. Aut corrupti dolores dolorum veniam repudiandae qui.
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...