Why does AutoSave in Office 365 only work on Microsoft OneDrive?!?

Anonymous
2019-02-03T21:53:24+00:00

Recently I lost power in my home after working on a spreadsheet for over three hours. Even though Auto-save was turned on in preferences, I lost ALL the work-- Auto-recover did not capture any of the changes, either. I had to spend the rest of the day re-creating my changes.

Needless to say, I was pretty pissed off, and went to research how Microsoft had managed to lose all my data. I first went to confirm that AutoSave was turned on, and found "Turn on AutoSave by default" checked on the Preferences/Save panel. However, in the document title bar, AutoSave displayed as "OFF" and was grayed out to the point of imperceptibility. This is true not just of Excel, but Word and Powerpoint as well.

I licensed Office 365 from GoDaddy, so I called their tech support line, and they gave me the incredible story that AUTOSAVE ONLY WORKS WHEN YOU STORE YOUR DOCUMENTS ON MICROSOFT ONEDRIVE - not natively on the Mac or on DropBox, which I've used for years.

****, are you kidding me? According to the "Datanyze.com" website, OneDrive has less than 9% of the "File Sharing" market, well behind DropBox, Box, and GoogleDrive. Even assuming that all Google users are backed up to Google's servers, 2/3 of users out there aren't able to automatically back up their changes because they don't use OneDrive.

Even worse, most have probably been head-faked by Microsoft into thinking that they're safe because AutoSave displays as automatically turned on in Preferences. They don't notice the obscure label in the title bar and don't find out it's actually not turned on until they're hit with a disaster like I was, and then wonder **** happened. 

This policy is patently irresponsible, and anti-competitive to boot.  In order to have AutoSave, you not only have to store your documents on OneDrive, you have to start them up from OneDrive - not your Mac hard drive folder icon - or AutoSave is still turned off.

Now, I'm back to the pre-cloud days of having to constantly remember to save documents as I make important changes to them. Seriously?!?

And don't suggest that AutoRecover will keep me covered in the absence of AutoSave: I've lost countless hours of work when AutoRecover does not do its job. Its reliability on the Mac has always been spotty.

This is crazy. Is Microsoft really willing to callously risk the data integrity of the majority of its users just to coerce them to switch to OneDrive?!?

IMHO, what Microsoft needs to do is:

  1. Display clearly in Preferences/Save that AutoSave is NOT turned on (and change the misleading "automatically as default" wording),
  2. State the reason (i.e. OneDrive required) so that users like me don't waste hours trying to determine whether it's just one more Office 365 bug,
  3. Add a local backup feature to Office 365 to automatically save to a hard-drive or competitive file sharing service (it can't be that hard),
  4. Stop being evil by claiming that not enough people have complained about the missing feature to justify its renewed availability.

Really, Microsoft should be ashamed of having pulled a stunt like this. It's an irresponsible, blatantly anti-competitive move, straight out of the naughty 80s.

[NOTE - this post has been updated to reflect the fact that AutoSave was a more recent development by Microsoft, not a long-standing feature.]

Microsoft 365 and Office | Excel | For home | Windows

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 No comments

90 answers

Sort by: Most helpful
  1. Jim G 134K Reputation points MVP
    2019-07-02T20:15:46+00:00

    The #1 question in the forums is "How do I recover unsaved work?'

    The answer is to train yourself to manually save your work periodically, or write a macro or add-in to handle this task automatically for you.

    Was this answer helpful?

    0 comments No comments
  2. Jim G 134K Reputation points MVP
    2019-06-29T16:48:30+00:00

    You're confusing two similarly named features that offer similar functionality.

    AutoSave is a relatively new feature that automatically turns on when you save a file to OneDrive or SharePoint. As Bob mentioned, the saving action is done on the server and are features provided by the server.  DropBox does not offer the service, although they could if they wanted to develop server technologies to provide such as service. Office apps currently offer sufficient extensibility via VBA, JavaScript, AppleScript and Objective C that I think any cloud service that wants to could make an add-in that would accommodate server-side backup and recover features. Drop Box has chosen not to add this functionality. It is their decision, not Microsoft's.

    AutoRecover has been around for decades and is on when you save your files locally (based on your settings in your app's preferences). This feature has not gone away.

    Excel Help offers a good explanation of how to recover files using both of these technologies.

    Recover files in Office for Mac

    What is AutoSave?

    Restore a previous version of a file without unwanted ...

    Was this answer helpful?

    0 comments No comments
  3. Bob Jones AKA CyberTaz MVP 437.7K Reputation points
    2019-06-26T19:22:44+00:00

    I've also read your reply to Jim but I'm sorry to say that it isn't accurate. There never has been an AutoSave feature in Mac Office. AutoSave was introduced in Office 2016 (version 16.12 in April 2018 IIRC).

    There are, however, 2 other features which often are misinterpreted as AutoSave:

    1. One is the AutoRecover feature listed in the Save Preferences. In Word, it does allow for specifying a file location in File Location Preferences, but by no means does it automatically save changes to the document, itself. It is provided only as a potential safeguard to help protect against loss of unsaved changes in the event of a critical failure.
    2. The other [in Word only] is Always create backup copy which is available in the Save Preferences, but it doesn't permit specification of a location... Backups are separate files generated in the same folder as the working document.

    Was this answer helpful?

    0 comments No comments
  4. Bob Jones AKA CyberTaz MVP 437.7K Reputation points
    2019-06-26T18:34:52+00:00

    Just a thought: Has anyone considered that AutoSave actually may be a feature of OneDrive/SharePoint which simply is supported by the Office apps rather than a feature of the apps, themselves?

    I'm not a developer, but If I were hosting a cloud I'd be very restrictive with regard to how content gets written to it.

    Was this answer helpful?

    0 comments No comments
  5. Jim G 134K Reputation points MVP
    2019-05-17T14:40:59+00:00

    Hi Stuart

    You did a good job explaining when AutoSave works: It works when you save to either OneDrive or SharePoint. It does not work with any other cloud service.

    AutoRecover works when you save locally to your computer's directories.

    Otherwise - make your own backup on your own terms. You can use VBA, AppleScript or JavaScrhipt to cook up any sort of backup interval and location that you want.

    Was this answer helpful?

    0 comments No comments