My auto save was on and set for to save every 10 minutes I saved a excel file myself about 2 weeks ago and opened it up to work on it today I had been working on it and creating multiple graphs that I needed for an assignment for hours then all of the sudden excel quit on it own and didn't give me an option to save my work it did pop up with a message to send to error to mac so I clicked send when I reopened excel it only had the file I saved two weeks ago and said it has not been modified since then when I had been work on it on and off for hours and my auto save was on to save every 10 minutes yet it didn't save once all of my work from those hours is gone and my assignment is due tomorrow I have excel quit on me unexpectedly often which is why I have the autosave on I am very disappointed and upset with excel and mac for this incident
I am using excel for mac. I set autosave to every 1 minute, then worked for a day until the app crashed and the latest auto recover file was a day old. I lost a day's work building a complex document with macros, formulas and many sheets.
I called customer (lack of) service and got the runaround several times, cut off two times. I then called Apple who led me to the auto recovery destination where there was only a single day old file present (excellent customer service at Apple by the way - in case you need any help). It was kind of them to help me that far, but they couldn't go any further with a microsoft product, so I'm trying the online comments to see if anything productive can occur.
I emptied the auto recovery folder and I have excel open for an hour now with autosave set to every 1 minute and the folder is still empty. Obviously this feature is not working.
Please, don't anyone say "you worked for a day and didn't save?" I'm not used to having to click save as Apple apps do that for you. Saving is a task from the 90's, the option shouldn't even exist. I'm surprised I don't have to key in the autoexec.bat command.
I'm only using Excel because my coworkers are all still using it rather than the lovely numbers app; I really have no choice.
The thought of calling microsoft's untrained phone operators again raises my blood pressure. Maybe something positive can happen by writing my message in this bottle and setting it adrift.
I'm amazed this hasn't received more votes. Maybe this problem doesn't affect everyone? All I know is that it's unbelievable to me that in 2016 I'd be working with a program from a major vendor that doesn't constantly (and successfully) autosave files. Today I lost about two hours of work because I made two mistakes. One was not saving as I went, which was partially because I was engaged in the work and partially because I'm out of the habit because EVERY PROGRAM I USE OTHER THAN OFFICE HAS A MODERN AUTOSAVE SYSTEM. My other mistake was using Excel 2016 instead of 2011, which is not 100% reliable on autosave but at least works most of the time. Excel 2016's autosave (or AutoRecovery) has never worked for me. But this time was the final straw for me. I'm going back to Excel 2011 - which, by the way, also crashes a lot less.