If you receive the above error when using Excel, there are two different solutions you can try. You should try one and if this doesn’t work, try the other.
- Within Excel, go to File -> Options -> Save and change the ‘AutoRecover file location’ file path to somewhere else on your computer.
- Navigate to the AutoRecover mentioned in the screenshot (in this case it was OneDrive as part of the organisation’s backup policy) and manually create a folder named ‘Excel’ in this location.
Manually creating the Excel folder has solved every case I’ve come across like this, but the first option is an alternative. The first method would not work due to the organisation’s policies (you could change the path but it would revert back), but it will work in a personal basis.
Additionally, in the cases mentioned, there was an organisation-wide issue where two OneDrive locations became mixed up, which is when this issue started happening. I discovered that manually creating the Excel folder (the AutoRecover folder already existed, as well as the Word folder within this folder) eliminated the issue.