Menu
To minimize the possibility of losing your work during a crash, here’s how to set your Microsoft Office documents to autosave every minute. This is a very fast save interval, but it will create an almost seamless backup history of your documents. This ensures that the most information you will ever lose in the event of a crash will be whatever you completed over the course of the last minute.
- Where Is My Microsoft Excel Autosave Folder On Mac Pro
- Microsoft Excel Autosave Location
- Where Is My Microsoft Excel Autosave Folder On Mac Free
- Where Is My Microsoft Excel Autosave Folder On Mac Download
- Microsoft Excel 2007 Autosave
For Mac:
The autosave folder is not to be used for anything else than autosaved versions of your ‘in the works’ Office docs. Autosave files are irrelevant in daily use, they only become important when Office crashes or something like that. You should save your regular Office docs wherever you like on your Mac, preferably somewhere in your Documents.
- In Word, go up and click the File menu item at the top of the screen > Preferences. From within this window, click Save.
- From here, make sure the “Save AutoRecover info” box is checked. The default number of minutes set in this box will be 10, so if you want to greatly increase your coverage in the case of a system failure, you can lower this to one minute.
Sep 11, 2019 Well, I have good news for you and it’s called Microsoft Office AutoSave! Files in sync on my PC and Mac with OneDrive with no issues. Cases in Excel. Autosave option is the life-saving feature of Microsoft that save all the unsaved data of excel file automatically during the unexpected excel file crash or any other issue. This option is very effective and able to deal with all types of data loss situations. Aug 22, 2017 AutoSave is a feature that works in Excel and PowerPoint 2016 for Office 365. If you don't have Office 365, you will not have AutoSave. You must save your files to OneDrive, OneDrive for Business. When you start Excel, all the files that are located in the XLStart folder are automatically opened. This behavior occurs regardless of the kind of file. Additionally, if you specified an alternative startup folder for Excel, every file in that folder is also automatically opened. To remove an.
Now, the only warning about putting your save interval that low is that it may make your system slow down. If you notice your system slowing down after this change, increase it incrementally until you find a happy compromise between protection and performance.
For Windows:
- In Word, go to the File menu > Options > Save. From there, you’ll adjust the settings the same way we did in the Mac version.
Finally, remember that you can save your document at any time by either pressing Command+S on a Mac or Ctrl+S on Windows. You can also save any time by clicking on the disk icon at the top of your window. This is always the most reliable way to make sure your work is preserved.
Click here to watch this video on YouTube.
-->Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
Summary
This article describes how to prevent files from automatically opening when you start Microsoft Excel.
More information
When you start Excel, all the files that are located in the XLStart folder are automatically opened. This behavior occurs regardless of the kind of file. Additionally, if you specified an alternative startup folder for Excel, every file in that folder is also automatically opened.To remove an alternative startup folder:
- Select the File menu and then select Options.
- Select the Advanced tab and then locate the General section.
- Clear the box next to 'At startup, open all files in:'.
Excel might stop responding or take longer to start if either of the following conditions is true:
- The files in either startup folder aren't valid Excel workbooks or worksheets.
- The files are stored on a network drive that has a slow network connection.
How to prevent files from automatically opening in Excel
Use one of the following methods to prevent files from automatically opening when you start Excel.
Remove files from the XLStart folder and the alternative startup folders
To remove files from the XLStart folder and the alternative startup folders, follow these steps:
- Select Start, and then select Run.
- In the Open box, type one of the following and press Enter:
- For Office365 or 2019 32 bit:C:Program Files (x86)Microsoft OfficerootxxXLSTART
- For Office365 or 2019 64 bit:C:Program FilesMicrosoft OfficerootxxXLSTARTWhere 'xx' represents the version that you are using (for example, Office15, Office14, etc.).
Also try the following:- %appdata%MicrosoftexcelXLSTART
- C:UsersUserNameAppDataRoamingMicrosoftexcelXLSTART
- Delete any files in the XLStart folder or move them to another folder.
- Restart Excel.
Start Excel in safe mode
Note
This is only a temporary solution that will not fix the issue. To use this method, it must be done every time that you start Excel.
Another method for preventing files from automatically opening is to start Excel in safe mode. Starting Excel in safe mode prevents all Excel add-ins, toolbar customizations, and startup folders from loading when the program is started.
Where Is My Microsoft Excel Autosave Folder On Mac Pro
There are two ways to start Excel in safe mode: the CTRL key and command-line switches.
Using the CTRL key
To start Excel in safe mode, hold down the CTRL key while you start Excel. You will receive the following message: Excel has detected that you are holding down the CTRL key. Do you want to start Excel in Safe mode? Select Yes to start in safe mode.
You can then delete files from the alternative startup location as described earlier.
Use Command-line switches
In all versions of Excel, you can use a command-line switch to start Excel in safe mode.Both the /safe switch and the /automation switch can be used for this purpose.
Note
The /safe switch starts Excel in safe mode. The /automation switch disables all automatically opened files and auto-run macros.
To use a command-line switch to start Excel, follow these steps:
Microsoft Excel Autosave Location
- Select Start, and then select Run.
- In the Open box, type either of the following lines (but not both):excel.exe /safeexcel.exe /automation
- Select OK.
Note
If Microsoft Windows Installer starts when you use one of these command-lines switches, clickCancel to finish starting Excel.
Press the ESCAPE key
Note
This is only a temporary solution that will not fix the issue. To use this method, it must be done every time that you start Excel.
Another method for preventing files from automatically opening is to press the ESCAPE key (but do not press and hold). When you press ESCAPE after the files start to open, Excel is prevented from opening additional files.
Where Is My Microsoft Excel Autosave Folder On Mac Free
Using this method, you may receive one or both of the following messages:
- Would you like to cancel opening all files from your Alternate Startup File Location?
- Would you like to cancel opening all files from your XLStart Location?
If you click Yes in either message, Excel starts without opening any additional files from the startup locations.
Where Is My Microsoft Excel Autosave Folder On Mac Download
Note
Do not hold the ESCAPE key. If you do this, the messages will be closed before you can click Yes.
References
Microsoft Excel 2007 Autosave
For more information about Excel startup folders, see the following Microsoft Knowledge Base articles: