Related Posts
After figuring out FI/RE I am less motivated.
What is the average yearly hike given in PWC?
Additional Posts in Excel Genius
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.







Manager got busy working on something else more important.
Wish that was the case!! All excel spreadsheets were set up with the same thought process!
Manager would appreciate the analyst taking the initiative to identify, call out, and offer to improve the load time if they understand where the load time hog is coming from.
The Manager doesn’t appreciate in changing the model to improve efficiency. There are macros created, manager does not how to fix if broken. The formulas are linked to a data tab that looks up the whole column and/or looks up additional blank rows, ex 50k, to include weekly new data added!!!!
Is it calculating something? You can disable "calculate on save" for those, I do that for my larger models.
Is it applying formulas/formatting in a table or to a whole row/column? If it's formatting the entire row/column then it could be taking a long time to do so. If it's not already within a table, I'd consider putting it in one.
Manager doesn’t use Excel “table”. It will make life much easier!
Correction, including the extra 50k+ rows was for the pivot tables.
If management is ok with spending 1-2 hrs saving files, what does that say about productivity?