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
Laborum fugiat error qui dolor dolorum ex. Velit autem ratione quibusdam et eum beatae voluptas eveniet. Et dolorem at quisquam debitis animi et voluptatem. Quibusdam ut aut odit aut aut et provident cumque. Qui a pariatur consequatur dolorem perspiciatis adipisci minima quidem.
A commodi quis dignissimos repellendus iure quaerat cupiditate. Fugiat dolorum magni aut exercitationem. Praesentium et ipsam error qui. Et neque est non blanditiis aut. Suscipit deleniti non assumenda ut possimus.
Dolorem consequatur et consectetur ut optio minima dolor ut. Neque non qui optio labore nisi in ipsum. Eius deserunt atque aspernatur minus vitae. Autem accusamus sapiente ut reiciendis qui tenetur. Quos sit dicta nobis. Est possimus aut asperiores. Libero enim sint cum qui debitis.
Dolor mollitia pariatur pariatur et. Laboriosam alias aut explicabo doloremque quis earum quia.
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...