If I now access these, the AutoSave is automatically aning that often before I can even disable this, Excel saves the file aning I lose the time stamp which used to show me when the last time was I worked on that file (which is very valuable information to me).Īm I the only person experiencing this problem? Am I missing some obvious trick? It feels to me that the AutoSave feature in its current form provides a safety net for people who do not save their work frequently (which is good) but without providing a workaround for others who already have a systematic approach in place. Now, while I do this for all my new files, I have a litany of old models which I keep as an audit trail. Therefore, I have to do it for each file individually. Now, I am aware that I can disable the AutoSave feature.BUT I cannot do this at a global level. Maintaining control of the 'Save' function is therefore crucial. Why? Because I sometimes test assumptions which I may or may not then want to keep permanently. However, what I do not want, is Excel saving my work automatically. In between saving these new versions, I do also save existing workbooks frequently. This worked well for me until the new Excel AutoSave feature was enabled.Īm I the only one frustrated by this? As a financial model developer, I frequently save new versions of the models I develop using a labelling system. Talk to experts about Microsoft Office 2019.As an independent financial modeller, I work on Microsoft One Drive as it ensures that my work is automatically backed up. Visit the dedicated forum to share, explore and
The document will save every 15 seconds (as set) If you need to run any code at intervals, the same. Reduce the risk of closing without saving. Documents based on this template will prompt for a save location on creation and will save automatically at defined intervals. If you have feedback for TechNet Subscriber Support, to learn more. Autosave document at selected intervals or run other code at intervals. Mark the replies as answers if they helped. Please try these methods and check if you can get any help from it. SelectĮxcel Add-ins > Go and then clear the check box for the add-in. Inactivate an add-in that's causing AutoSave to be disabled.Table Tools Design > Refresh > Connection Properties. Select the table or PivotTable, then go to Turn off the Refresh data when opening file setting on all tables and PivotTables in the file. If you are opening a workbook snapshot from SharePoint, choose to open the file instead of the snapshot.> Info > Protect Workbook > Restrict Access and click If possible, remove restricted access: Go to File.
If you have forgotten to turn on or enable the AutoSave feature in Excel application, you will not be able to use it for automatically saving and backing up Excel files on Windows PC. If you are using Excel, and tried the above, you may have a file that contains features that are not supported by AutoSave. Quick Fix: Check and enable AutoSave feature in Excel application. Your presentation is in slide show mode.Your file is embedded inside another Office file.For more information on updating OneDrive, see Get started with the new OneDrive sync client in Windows. Your file is being synced by an older version of the OneDrive sync client.Your file is in a local OneDrive folder and OneDrive synchronization is paused.Here are some common reasons for it to be disabled: There are other reasons AutoSave could be disabled as well. On Premises site, a file server, or saved to a local path like C:\. This will happen if your file is on a SharePoint This feature is only available for Office 365 subscribers, i f the file is saved to another location (or if it hasn't been saved at all, yet), then AutoSave is disabled. I suggest you check if you sync OneDrive or SharePoint automatically. What version number of Office did you use? Please go to File- Account and provide the information as shown in the following picture:Īs far as I know this feature is used to autosave to OneDrive or SharePoint.
Did this problem appear in all Excel files? How about creating a blank Excel files?