Open the Utilities folder and open Terminal (I personally use iTerm). So, say your original file "Budget.xlsx" was saved to "AutoSave to 1BADF522Budget.xlsx". If "staff" is not an entry option (it wasn't in mine) you'll have to execute "chmod 644" (without quotes) from the command line in the Terminal app.
Add in any elements missing from the above and set the privileges as shown. Click and unlock the padlock icon on the bottom right of the section. They should read as follows:Ĭlick the black triangle to expand the section (if it isn't already expanded.). From Finder, right click on the target's icon and select "Get Info". Change the target file's permissions & Unhide. Excel appends a prefix string to the beginning of the file name which reads "AutoSave to " (all without quotesģ. If it is hidden and/or compressed, its icon's color will be muted if Finder is configured correctly. Open the AutoRecovery folder and locate your desired file. (Or you can Google instructions for your versionĢ. Http://.uk/articles/quickly-showhide-hidden-files-mac-os-x-mavericks/ is one of many web pages that has walk through instructions demonstrating how you can do this for both Mavericks & Yosemite. (Your may prefer to configure Finder to see hidden files. Using a web browser, open the file directly from SharePoint or OneDrive where the file is stored.File:///Users//Library/Application Support/Microsoft/Office/Office 202011 AutoRecovery/.Open the Office app, click on File > Open and navigate to the server location (OneDrive or SharePoint).If you are continuing to experience or have not updated yet, you can use the following workaround:
To get the update immediately, open any Office 2016 app and choose File > Account > Update Options > Update Now. This issue is now fixed in Version 1708 (Build 8431.2094). This issue impacts the Office 2016 August 2017 update, Version 1708 (Build 8431.2079) and later. Save to OneDrive or SharePoint Online if you want to use AutoSave. This file location doesn't support AutoSave. Hovering over the AutoSave toggle, the tool tip will prompt you with the following message:ĪutoSave Not Available. I'm still looking into this.ĪutoSave is disabled for OneDrive, OneDrive for Business, and SharePoint locationsĪfter opening a file saved in OneDrive, OneDrive for Business, or SharePoint that is synced using a sync client, you may experience that the AutoSave is incorrectly disabled or greyed out. I have checked our build versions and though they're not the same, autosave is now disabled which is great news for us. There is however some info i found in Excel help that talks about the build versions. So you might want to check the bit version and excel version. So we had to move the files back to disk (SAN) storage where its disabled. We dont want autosave in my organisation, because when finance team work collaboratively they dont want to autosave every little thing they do.
Autosave (for Excel) i think might be enabled only for 64-bit versions, and is automatically enabled for spreadsheets (xslx files only older versions of Excel arent affected) saved in OneDrive/SharePoint online.