Forum Discussion
bmwever
Nov 22, 2021Copper Contributor
Excel AutoSave turned off
My organization has a Windows 10 Excel 365 spreadsheet synced with OneDrive that we use for coordinating projects. One of our users cannot use autosave on his computer because it always asks him to s...
- Dec 02, 2021While I was reviewing Office's and OneDrive's configurations yesterday, I noticed that Windows still has two OneDrive folders with the blue cloud inside the File Explorer icon. This seemed strange because we had already signed out of the unnecessary OneDrive and Office accounts. Once we created a new Windows profile, Excel's AutoSave feature began working correctly again as we wanted.
rob_tito
Nov 24, 2021Copper Contributor
I work using Excel sheets a lot, so most times i run into problems like this. In situations like this i try to
- Ensure that the Auto-save feature is enabled
- Re-save Office Temp files
- I try to see if they are any corrupted files
- You may also encounter problems like this, when dealing with older formats that are not supported.
If your colleague goes through the bullet points, and still gets the error, then i suggest your https://www.thewindowsclub.com/autosave-feature-not-working-office.
bmwever
Nov 30, 2021Copper Contributor
rob_tito, thank you for the suggestions.
- Ensure that the Auto-save feature is enabled: As I mentioned to Martin_Weiss, the settings are already configured correctly in Excel's options fields. Also, the switch at Excel's top-left corner keeps turning itself off automatically whenever we try to turn it on (this is the whole problem I'm trying to solve).
- Older format: The document already is an XSLX file, which we're accessing from OneDrive, which therefore ensures that we're all using the same document.
- Fix corrupted file: See the second part of #2. Other people can accesss it as expected at the same time, just not this one user.
- Resave the temp files: Wouldn't this be done as part of #5? If not, feel free to correct my understanding.
- Repair/reinstall Office: I already attempted this, but the problem persists.