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: Newest
  1. Jim G 134K Reputation points MVP
    2020-03-20T02:36:47+00:00

    This content has been removed by the author.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2020-03-17T17:48:33+00:00

    Jim - I read the "File recovery and version history - Dropbox" you referenced, and nowhere does it claim to be able to AutoSave your documents. It just lets you recover accidentally deleted files and view version history FOR FILES YOU HAVE ALREADY SAVED. The same goes for Apple Time Machine - it can only retrieve previously saved copies.

    That's not AutoSave - it's AutoRecover. The user still has to initiate a save from the source app, which in this case is MS Word or Excel. DropBox doesn't help you until you've already saved the document somehow. THAT IS NOT THE USE CASE EVERYONE IS MAD ABOUT.

    Microsoft is hiding behind cloud techno-BS to justify the extortion of requiring OneDrive for a simple AutoSave. I'd really like to see  an *official" explanation as to why it would be so difficult for Mr. Softie to allow its apps to periodically SAVE a document back to WHATEVER FOLDER YOU OPENED IT FROM, whether it's on the cloud or not. "Save" and "Save As" can certainly figure that out today.

    I really feel like they're gaslighting us all who remember setting a 1-2-5-10...-minute interval for a document to be saved, whether the facility was actually AutoRecover or not. And it actually worked, reliably. 

    MICROSOFT ARE YOU LISTENING? CAN GIVE US AN EXPLANATION? (And please, please, do not tell me that the answer is AutoRecover - by common experience, it just doesn't work often enough to rely on).

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2020-03-17T17:17:25+00:00

    Jim, I initially started this thread because Windows took away my ability to autosave Word and Excel documents to the local drive as it had done for decades.   I didn't like Microsoft forcing me to push documents to any cloud, and taking away functionality in order to do so.   Now more than a year later I've adjusted to doing frequent manual saves.  The community took my comment and ran with it in other directions, such as those you refer to above.

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments No comments
  4. Bob Jones AKA CyberTaz MVP 437.7K Reputation points
    2020-03-17T14:59:30+00:00

    Really, Jim, hasn't this perpetual ****-fest gone on long enough?

    After more than a year of the same "Microsoft won't cater to my specific wishes or protect me from myself" griping IMO it's about time this thread gets locked.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  5. Jim G 134K Reputation points MVP
    2020-03-17T14:03:02+00:00

    Dropbox has its own backup system.

    File recovery and version history - Dropbox

    I am puzzled when people complain that one company (Microsoft) doesn't have control over another company (DropBox). They're two separate companies. Microsoft doesn't control everything. They control OneDrive and SharePoint, which is why the AutoRecover feature works with these cloud storage products.

    As for the decades-old AutoRecover feature, why complain unless you use Microsoft Windows? In Mac OS we have Time Machine built right into the operating system. Time Machine is far more robust and works with ALL your files, not just Office files. AutoRecover is simply an old technology that really isn't needed on Macs.

    Use Time Machine to restore deleted files or older files ...

    Was this answer helpful?

    0 comments No comments