If you use the file auto recover/ save option in Excel, which I suggest you do. (I learned the very very hard way years ago whilst doing some analysis for my Thesis, my file corrupted after a hefty session on analysis and my auto save was not enabled). Ouch!, Never repeated though I am glad to say.
So back to changing the system default location of Excel auto save file. Its really easy to change to a file location of your choosing.
- Office Button
- Excel Options
- Save- Save Workbooks area
- Auto recover file location- amend as required