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-03-05T18:36:54+00:00

    Still not germane to why Office365 won't autosave to the Dropbox folder.  Furthermore, for reasons I fail to comprehend, Microsoft documents saved to Dropbox get moved to "Documents".  

    Yes, I know HOW to manually make backups to Dropbox.  I'm saying that Microsoft is deliberately making it difficult to do anything BUT manual backups to Dropbox.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2020-03-04T20:06:08+00:00

    What I meant was not all the extra features the current implementation of AutoSave provides to be made drive/cloug agnostic, I think I can say that we all here understand what AutoSave is. What we argue is that there isn't a dead simple feature that used to exist that basically automatically saves your document for you every x minutes. No version history, no cooperative or simultaneous or whatever editing, nothing fancy. Just save the bloody document automatically, regardless where it is. Press ctrl+s every minute for me. That's it. It isn't rocket surgery and this feature existed.

    I understand that there's AutoRecover, and what I was arguing, is that it is entirely useless. For me, it might have worked around 5% of the time when I had power loss or anything that resulted in loss of work.

    The bottom line is that if I'm not using OneDrive when editing a document, i'm utterly screwed if the software crashes (happens more often than you think), I have a power loss or anything else. I lost enough time lately because of the lack of such feature, I might as well return using paper an pencil. Certainly more advanced than the office suite in terms of reliability of data storage.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2019-02-05T19:43:40+00:00

    Yes, I usually set to "Every 5 minutes" just so I don't lose much work.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments
  4. Anonymous
    2019-02-05T12:04:22+00:00

    The suggested location for the autorecovery files is wrong. At least for my version of Excel (16.21.1 - 365 version for Mac). The correct location is:

    /Users/<username>/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft/<your filename><some number>

    See here for more information on how to get to this folder. Good luck!

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments
  5. Anonymous
    2019-02-04T10:06:13+00:00

    Hi LK Hill,

    Really sorry to hear that, we apologize for all the inconvenience.

    The auto-recover feature is built up to handling this kind of scenario, next time if your Office quit by accident, please double check the following path to find if you can retrieve your files:

    /Users/<username>/Library/Containers/com.Microsoft.Excel/Data/Library/Preferences/AutoRecovery

    We do understand your requirement on AutoSave files locally, but please allow me to explain on this, for the user whose files are stored in OneDrive or SharePoint Online, every few seconds, their changes to the files will be synced to the cloud. Meantime all the major vision of your file will be saved as a version history copy in the OneDrive, which allow you to retrieve an old version on this file easily.

    This is only my opinion, but take a few seconds to think the following scenario: If you have enabled AutoSave locally, what if the Office App saved the content or format style you don't actually want to apply. And there is on version history to retrieve on a local environment.

    We are deeply sorry for your data loss, we truly understand that some user might be misled by the AutoSave title and ignore the little label.

     

    We would kindly suggest you feedback on this directly to the related resource by the following method:

    How do I give feedback on Microsoft Office?

    Best Regards,

    Alex Chen

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments