AutoSave switch greyed-out.

Anonymous

A couple of days ago, I noticed that the save icon at the top of the Excel window in version 1707 of Office 365 has been moved a little to the right because a new greyed-out AutoSave button has appeared. It is set to "Off".

Does anyone know how to turn it on?

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous

this is from:

https://support.office.com/en-us/article/What-is-AutoSave-6d6bd723-ebfd-4e40-b5f6-ae6e8088f7a5?ui=en-US&rs=en-US&ad=US

"AutoSave is enabled when working on a file that is saved to OneDrive, OneDrive for Business, or SharePoint Online. If the file is saved to another location, then AutoSave is disabled. This will happen if your file is on a SharePoint On Premises site, a file server, or saved to a local path like C:.

There are other reasons AutoSave could be disabled as well. For example, if your file is in an older format like .xls, .ppt, or .doc., it will be disabled. It will also be disabled if your presentation is in slide show mode, or if your workbook contains password protection. If AutoSave is disabled, you can always hover over the AutoSave switch and a tooltip will tell you why it's off."

0 comments

49 additional answers

Anonymous

2018-03-02T19:26:40+00:00

Great. This does answer my question, kinda. But it doesn't completely fix the issue I have, and forces me to jump through unnecessary hoops.

So, it's still cumbersome as hell… Auto-save will only become available (and switch itself on) if I open the file through the File > Open menu in Word, and then select “Online Sources”. Even if the file is saved in OneDrive, if I open it through the Finder, Word will essentially treat it as any regular old file.

Worse: if I drag the proxy document icon from the titlebar to a folder or to the Dock to create an alias/shortcut, even if I do so having opened it through the File > Open menu as stated above, said alias/shortcut will still behave as if I would be opening the file directly from its location.

I mean, OneDrive already has special access to the Finder via a macOS extension; how hard could improving its integration be? I am currently working in my MFA thesis, and I like having one-click access to my working file directly through the Dock, is that too much or exotic to ask?

To make matters worse, I have this stupid bug in Word/OneDrive which prevents the latter from syncing any file changes after saving it until I quit the former. Maybe if I just open the files through File > Open that won't be a problem? Still, it would be a terrible user experience by any account or measure. I never had this kind of issues back when I was using Dropbox…
Was this answer helpful?

0 comments No comments
Anonymous

2018-03-02T21:19:51+00:00

Perhaps try repairing the application to see if that corrects your problem:

https://support.office.com/en-us/article/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b
Was this answer helpful?

0 comments No comments
Anonymous

2018-03-03T14:38:36+00:00

It's not working in the Mac to!

We work with .xlsx files. Seems like the latest.

Checkbox is on "Save AutoRecover info every 5 minutes"

Excel crash 2 times a hours... and doesn't make any recover data!

OK we can save Control+S every 5 minutes, but thats not the way of working!

The stability of the program is a minimum.

Just buy this year the new Office package. But I have a lot of craches on my MAC.
Was this answer helpful?

0 comments No comments
Anonymous

2018-03-03T14:55:30+00:00

Again it crashed.

Can MICROSOFT support check the Copy-Paste (with short-cut) function. A lot of time it crashed at that time. Copy 5 cells with a brand new iMac 27" and brand new Microsoft!

Thanks for helping me out!
Was this answer helpful?

0 comments No comments