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. Anonymous
    2020-01-03T23:11:26+00:00

    I use Dropbox not OneDrive for my synchronization of local data.

    Why can't Microsoft Word do autosave to local drive in order to enable Dropbox to do synchronization?

    This is crazy.

    If the autosave function exists in the software it actually takes Microsoft EXTRA programming to disable it unless the local file is on a OneDrive.

    This question was raised by original poster and I don't see where it was ever answered.

    It looks like you are evading the question.

    Why can't Microsoft Word do autosave to local drive in order to enable Dropbox to do synchronization?

    Thank you.

    Art

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2019-06-26T19:07:02+00:00

    Good idea, Jim - thanks. I just added this suggestion, under the subject, "Add local Mac support for Auto-save":

    "In earlier versions of Office for Mac (e.g. 2011) the auto-save function saved a copy to wherever on the Mac hard drive you desired - either a native folder, or iCloud or DropBox. Then 2016 and Office 365 came along and slyly required you to license OneDrive in order for this function to work. FOUL PLAY!  Make it work on the native hard drive and other (more popular) cloud file-sharing services again."

    And wouldn't you know, the Microsoft feedback facility choked on the suggestion, and went into infinite "processing" mode:

    Note the arrow-circle next to "Post Idea." It's been going for 10 minutes now...

    In any case, I don't have any great hopes for this approach, since few users know about the Idea facility, and Microsoft just uses the dearth of votes for these ideas an justification for continuing their anti-competitive ways...

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2019-06-20T06:31:44+00:00

    Thanks for initiating this thread. I'm merely a non technical user and this drives me nuts.  Have been using Dropbox for about 10 years for my small business and personally - easily sharing with my business partner and family. I don't want to switch to OneDrive, so find this feature (or lack thereof) very frustrating. FFS Microsoft, spend some of your billions sorting this. Wouldn't it be nice to have happy customers?

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments No comments
  4. Anonymous
    2019-06-19T20:06:17+00:00

    The answer is - you can't back up to DropBox (see my original post at the top.) You can ONLY Auto-save to OneDrive.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments No comments
  5. Anonymous
    2019-03-12T17:26:22+00:00

    There are those of us who do not wish to use the Microsoft Cloud or OneDrive so the suggestion that this is a helpful change is self-serving.  It clearly comes across as way to force us to the cloud; otherwise, we would be given the option to continue auto-saving locally.  The local "Auto Save" has been in place probably 25 years yet removing that functionality was never communicated to Office users.  With the local copy, the issue you present of saving an unwanted change is very weak considering the history and considering the far more common scenario of losing intended changes without it.   OneDrive is not necessary to recover.  The previous version is in 'File History' of the last backup which for most is daily.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments No comments