Others have actually answered your question…
As some one who has been doing software consulting for years now, I would like to express, if you have that many inter-dependent excel sheets open at a time that you find the prospect of opening/closing them that painful, its time to get your IT/Software department involved.
If you are storing important data in excel it should be in a database, if you are spending a lot of time and effort transforming existing reports so you can do your own work, then your reporting tools should be able to streamline that process for you and ensure that you aren’t working with stale data or data that has changed since you brought it offline…
Its also pretty easy to argue for with management (I spend N hours creating these reports, that costs the company $x in my time, and the process is complicated enough that onboarding some one new would take N months, and would be incredibly error prone), that cost would be reduced to almost zero with just a little bit of engineering effort.
Latest Answers