advertisement
Forums

The Forum is sponsored by 
 

AAPL stock: Click Here

You are currently viewing the Tips and Deals forum
Excel v16 Users - Does autosave really not work?
Posted by: tuqqer
Date: July 27, 2021 11:28AM
I have a standalone version of Excel (16.49) and was working all day on an open Excel spreadsheet, adding things throughout the day. I stopped working around 6pm and just let everything along for 5 hours until 11, when I came in to shut down the Mac. I did the shutdown really fast, and as the Mac was closing down apps, Excel came up and asked if I wanted to Save anything. I presumed, since I hadn't made any changes for 5 hours to any open docs, that there was nothing to save, so I automatically just said no.

I wake this morning, open up that doc, and no changes from yesterday were saved. I then thought no worries, I'll go into Time Machine and get the backed up version from around 5pm. TM did its thing, and same deal: absolutely no changes were saved from yesterday.

All my files live on my hard drive, same drive that all my apps are on. I'm not saving to iCloud, or using a different drive than the one the OS is on. All basic behavior.

IS there an autosave feature on Excel v16 standalone? Was this SOP and there is, in fact, no autosave? I looked around in the settings and aside from 3 already checked boxes in the Preference Save tab (none which looked related to autosave).



Mac mini (M1 2020, 16G 2T) Big Sur 11.x Dual 25" Acer 1440p LCDs11" i5 MacBook Air



Edited 1 time(s). Last edit at 07/27/2021 11:30AM by tuqqer.
Options:  Reply • Quote
Re: Excel v16 Users - Does autosave really not work?
Posted by: Gareth
Date: July 27, 2021 12:14PM
There's some terminology to clear up and this article might shed some light: [support.microsoft.com]

In a nutshell, that's correct. There's no "AutoSave" in standalone Excel. AutoSave is a cloud feature for 365 users (i.e. it will only AutoSave to the cloud, not your computer's local drive), and it still needs to be enabled on a document basis (there's a toggle switch for it in the top bar of the document).

What you do have is "AutoRecover" which saves temp files in the event of a crash or unexpected shutdown, however, these files are deleted every time you save (and were likely also deleted when you chose not to save, since that was still a controlled closing of the application).



Edited 1 time(s). Last edit at 07/27/2021 12:14PM by Gareth.
Options:  Reply • Quote
Re: Excel v16 Users - Does autosave really not work?
Posted by: tuqqer
Date: July 27, 2021 01:42PM
Thank you, Gareth. I will definitely get back into the Command-S habit with this app from now on.



Mac mini (M1 2020, 16G 2T) Big Sur 11.x Dual 25" Acer 1440p LCDs11" i5 MacBook Air
Options:  Reply • Quote
Re: Excel v16 Users - Does autosave really not work?
Posted by: Gareth
Date: July 27, 2021 01:51PM
Yea, I can see where this might cause confusion between Apple (and other) apps which have implemented the MacOS "autosave" feature and third-party apps where that isn't implemented. I spend so little time in apps that support Apple's autosave, that I'm frequently confused when I do use them (i.e. Preview). Especially the loss of "Save As" as I end up making duplicates of documents I didn't mean to.
Options:  Reply • Quote
Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 90
Record Number of Users: 186 on February 20, 2020
Record Number of Guests: 5122 on October 03, 2020