A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Thanks, Hond, Unfortunately, no auto-recover file there either for my missing spreadsheet...
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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:
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.]
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
Thanks, Hond, Unfortunately, no auto-recover file there either for my missing spreadsheet...
Sorry for asking, but you never know...
Did you check the menu Excel > Preferences > Save to see if "Save AutoRecover info in every x minutes" has been checked?
Yes, I usually set to "Every 5 minutes" just so I don't lose much work.
The MVPs will be meeting with Microsoft next month. I will take up this cause and present these suggestions. Sometimes I think the general public has more influence over the Microsoft decision making process than the MVPs have, but at least I can raise the issue.
That would be great, Jim - thanks very much.
In the meantime, I've outlined this issue on a number of other websites, forums and periodicals. It will be interesting to see if it gains any traction in the Mac/Office 365 community.