Ever found yourself working tirelessly on an Excel spreadsheet, only to realize you've lost hours of work due to an unexpected power outage or system crash? The frustration is real, but it's a scenario that can be easily avoided with Office 365's Excel Autosave feature. Let's delve into the world of autosave in Excel, its benefits, how it works, and where your work is stored.
Excel Autosave is a lifesaver for anyone who spends considerable time working with spreadsheets. It automatically saves your work at regular intervals, ensuring you never lose your progress. But where does this autosaved data go, and how can you access it? Let's explore these aspects in detail.
Understanding Excel Autosave
Before we dive into the autosave location, it's crucial to understand how Excel Autosave works. In Office 365, Excel automatically saves your work every 10 minutes. This interval can be customized, but the default setting is designed to balance the need for frequent saves with minimal disruption to your workflow.
Autosave also kicks in when you make significant changes to your spreadsheet. For instance, if you've been working on a complex formula or a large data range, Excel may save your work more frequently to ensure nothing is lost.
Autosave vs. Manual Save
While autosave is a powerful feature, it's essential to understand that it doesn't replace manual saves. Autosave is designed to protect your work from unexpected losses, but it doesn't save every keystroke. If you want to preserve every change you make, you'll still need to manually save your work periodically.
Moreover, autosave doesn't overwrite your manual saves. When you manually save your work, Excel creates a new version of the file, allowing you to revert to previous versions if needed. Autosave, on the other hand, continually updates the current version of the file.
Autosave Interval and Location
Now, let's talk about where autosaved data is stored. By default, autosaved files are stored in a hidden folder on your local machine. The location of this folder varies depending on your operating system:
- Windows:
C:\Users\\AppData\Local\Microsoft\Office\UnsavedFiles - MacOS:
~/Library/Application Support/Microsoft/Office/UnsavedFiles
To access these autosaved files, you'll need to enable the visibility of hidden files and folders in your operating system's file explorer.
As for the autosave interval, as mentioned earlier, it's set to 10 minutes by default. However, you can change this interval to suit your needs. To do this, go to the 'File' tab in Excel, click on 'Options', then 'Save'. Here, you can adjust the 'Save AutoRecover information every' field to your preferred interval.
Recovering Autosaved Files
Now that we know where autosaved files are stored, let's discuss how to recover them. There are two primary methods to do this:
Recover Unsaved Workbook
If Excel crashes or closes unexpectedly, you can usually recover your autosaved work using the 'Recover Unsaved Workbooks' feature:
- Open Excel and click on the 'File' tab.
- In the 'Info' section, click on 'Manage Workbooks'.
- In the 'Open' dialog box, click on 'Recover Unsaved Workbooks'.
- Select the workbook you want to recover and click 'Open'.
This will open the autosaved version of your workbook, allowing you to continue working from where you left off.
Manually Accessing Autosaved Files
If you want to access autosaved files directly from the hidden folder, you can do so by following these steps:
- Navigate to the UnsavedFiles folder (as mentioned earlier).
- Look for files with the extension '.asd'. These are your autosaved files.
- Rename the file to include the date and time it was autosaved (e.g., 'Workbook1_2022-03-15_14-30.asd').
- Close the file if it's currently open in Excel.
- Rename the file again, this time changing the extension to '.xlsx'.
- Open the file in Excel. It should now open as a regular Excel workbook.
Remember, autosaved files are temporary and will be deleted after a certain period. If you want to keep your autosaved work, make sure to manually save it once you've recovered it.
In the dynamic world of office work, losing hours of progress due to unexpected crashes can be disheartening. But with Office 365's Excel Autosave feature, you can work with peace of mind, knowing your progress is always safe. So, go ahead, dive into your spreadsheets, and let Excel take care of the rest. Happy spreadsheeting!