I have an Excel spreadsheet that has a lot graphs that are build from data that is built with a lot of INDIRECT() calls. As a result, it takes a few minutes for all of the resolution/calculation to complete. Now, since auto-calculation is the default setting, if someone wants to view my spreadsheet (including me), opening the file takes a long time. Since it's my file, I know to turn on manual calculation first and then open the file -- but my colleagues don't always know or remember that.
So, I'm looking for a way (I presume via macros) to turn on manual calculation whenever the file is opened, somehow notify the person opening the file that manual calculation has been turned on, and then do the reverse whenever the file is exited (i.e. turn auto-calculation back on and notify them that this has been done).
Can this be done? If so, any pointers on how? Also, if I have multiple workbooks open, is there a way for auto-calculation to be on for some of the files and manual calculation to be on only for this particular spreadsheet?
Thanks...
So, I'm looking for a way (I presume via macros) to turn on manual calculation whenever the file is opened, somehow notify the person opening the file that manual calculation has been turned on, and then do the reverse whenever the file is exited (i.e. turn auto-calculation back on and notify them that this has been done).
Can this be done? If so, any pointers on how? Also, if I have multiple workbooks open, is there a way for auto-calculation to be on for some of the files and manual calculation to be on only for this particular spreadsheet?
Thanks...