Excel Autosave to local storage, how to enable this?

On Excel 16.32 (O365-Biz) on OSX. When I try to enable Autosave it will only permit me to use OneDrive, One Drive for Business or Sharepoint. None of these are viable to me. I am a consultant and must keep my files on local encrypted storage.

How can this function be configured to use local storage only?

You can't.


The new "autosave" feature that was forced onto your QAT ONLY works with OneDrive.

If you want to create timestamped, or version numbered, "autosaves" to your local drive you will need to use an addon or macros.


Autosave- Save the current document in two locations add-in for Word 2007 & 2010 and Excel
Originally conceived as part of the Save Numbered Versions add in, it was suggested by my friend and frequent collaborator Greg Maxey, that it would be better to retain its individual identity. I have therefore acceded to his suggestion and produced the add-in as a separate entity which does not require the presence of the Save Numbered Versions add-in, but will nevertheless work happily alongside it.

AutoSaver is a free application that autosaves files from applications you designate. You can download it here. Basically, you select your apps and then at what frequency you want to save. Or you can set it to autosave every app with some exceptions.

autosave as macro in excel
I have written a code in excel that save as excel file in another location when user clicks save button.
ET MR Macros.docx.

Here is some general info about the MS Autosave feature

@ How AutoSave impacts add-ins and macros     01/01/2019
Learn about how AutoSave works in Excel, PowerPoint, and Word, and how it can impact add-ins or macros. When a file is hosted in the cloud (that is, OneDrive, OneDrive for Business, or SharePoint Online), AutoSave enables the user's edits to be saved automatically and continuously. When the file is shared with others, their changes are merged into this user's version of the file. If AutoSave is turned off, save must be triggered manually for the user's changes to be persisted in the cloud and for this user to receive others' changes. Currently, Excel, Word, and PowerPoint provide a BeforeSave event that allows a developer to execute code after the user triggers a save but before the save occurs. Excel also provides an AfterSave event that can execute macro or add-in code after the save completes.

As computer scientists we are trained to communicate with the dumbest things in the world – computers –
so you’d think we’d be able to communicate quite well with people.
Prof. Doug Fisher

12 people found this reply helpful


Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.


Question Info

Last updated August 27, 2021 Views 2,390 Applies to: