See all How-To Articles This tutorial demonstrates why AutoSave might be grayed out or not working in Excel. AutoSave is a new feature in Office365 that allows you to save your work in real time, meaning it automatically saves every few seconds as you work. To enable AutoSave, files must be saved to OneDrive or SharePoint. If you are actually trying to fix AutoRecover, scroll down to the last section of this page. AutoSave Not WorkingAutoSave Feature DisabledIf AutoSave is not working, the first thing you should check is whether the feature is disabled in Excel Options. If it’s disabled, follow these steps to get it working:
Not Saving Files to OneDrive or SharePointThe AutoSave
feature is available only if you are working on files that are saved on OneDrive or SharePoint. So, if you are working on an unsaved file, or on a file saved locally on your computer or offline, you won’t be able to turn AutoSave on. Try saving to OneDrive first. Corrupted FileIf an Excel file is corrupted, AutoSave doesn’t work. Repair the corrupted file to fix the problem.
After clicking Repair, the window pictured below appears with repair information about your file. To finish with the process, click Close. If the repair process didn’t fix the problem, choose to Extract Data. Unsupported File FormatAutoSave is not supported in older formats such as .ptt, .doc, or .xls. To fix this, change the file extension to the latest. To check the file extension just look at the title bar, it should be .xlsx. If it is not, rename the file with that extension. Security Features Turned OnAnother potential reason AutoSave doesn’t work is because the workbook contains features that are not supported by it. You need to remove password encryption, remove restricted access, and also turn off sharing feature and turn off Refresh Data when opening. There is a possibility that an add-in might have disabled the AutoSave feature, so you should turn add-ins off.
Repair or Reinstall Microsoft OfficeIf you tried everything above and nothing seems to work, consider repairing or reinstalling Excel. To repair the Microsoft Office installation, follow these instructions:
After this, your Microsoft Office installation is repaired. The last option is to uninstall and then reinstall Microsoft Office to see if the AutoSave feature problem is still there. AutoRecover Feature Not WorkingAutoRecover is a feature in prior versions of MS Office (2003/2007/2010/2013/2016/2019) that automatically saves your work at regular intervals. (The default interval is 10 minutes, but you can adjust it.) AutoRecover keeps a temporary copy of your work and saves it every 10 minutes. It is even
available when you save files offline or work on a file without saving it.
Why is save as greyed out in Excel?If the Admin has chosen not to allow saving and editing to a specific, the save button will be greyed out.
How do I get permission from Excel to save on a Mac?Click the Apple menu>Choose System Preferences > Security and Privacy > Privacy>Click the lock in the lower left corner and enter your system password>In the left panel choose Full Disk Access and in the Right panel choose Microsoft Excel.
How do I enable Save button in Excel?Adding "Save" Button in Excel
If you want to add a VBA save as button in Excel, you can do so using the "Developer" tab in the ribbon menu. Make sure you have enabled it by customizing the ribbon, and then click the "Insert" button; under "ActiveX Controls," click the word "Button."
How do you unlock the greyed out menu in Excel for Mac?To unprotect your worksheet, head to the Review tab and click on the Unprotect Sheet option. If the sheet is password-protected, you will be required to provide the necessary password. After unprotecting the sheet, the grayed out menus should now be unlocked and ready to use again.
|