Excel Functions Tutorials
- Excel Tips
- Excel vs Access
- Excel Rows vs Columns
- Apple Numbers vs Excel
- 3D Reference in Excel
- Absolute Reference in Excel
- Mixed References in Excel
- Excel Reference to Another Sheet
- Array Formulas in Excel
- Arrays in Excel VBA
- Auto Numbering in Excel
- AutoFit in Excel
- AutoCorrect in Excel
- AutoSave in Excel
- AutoRecover in Excel
- Bullet Points in Excel
- Break Links in Excel
- Barcode in Excel
- Change Case in Excel
- CAGR Formula in Excel
- Calculate Age in Excel
- Calculate Percentage in Excel Formula
- Cell Reference in Excel
- Checklist in Excel
- Circular Reference in Excel
- Column Sort in Excel
- Column Lock in Excel
- Move Columns in Excel
- Custom List in Excel
- Consolidate in Excel
- Combine Cells in Excel
- Compare Two Columns in Excel
- Compare and Match Columns in Excel
- Compound Interest Formula in Excel
- Convert Columns to Rows in Excel
- Convert Date to Text in Excel
- Convert Numbers to Text in Excel
- Convert Text to Numbers in Excel
- Convert Excel to CSV
- Count Characters in Excel
- Count Rows in Excel
- Count Unique Values in Excel
- Countif not Blank in Excel
- Create Templates in Excel
- Family Tree in Excel Template
- Custom Number Format in Excel
- Delete Row Shortcut in Excel
- Divide in Excel Formula
- Drop Down List in Excel
- Dynamic Tables in Excel
- Dashboard in Excel
- KPI Dashboard in Excel
- Date to Text in Excel
- Date Format in Excel
- Database in Excel
- Delta Symbol in Excel
- $ Symbol in Excel
- Excel Column to Number
- Edit Drop-Down List in Excel
- Equations in Excel
- Exponents in Excel
- Excel Extensions
- Excel Translate
- Excel Not Responding
- Excel Find and Replace
- Find and Select in Excel
- Excel Subtraction Formula
- Excel Formula for Grade
- Excel as Calculator
- Excel Formula Not Working (Updating)
- Excel Table Styles & Formats
- Excel vs Google Sheets
- External Links in Excel
- Excel Alternate Row Color
- Excel Worksheet Tab
- Extract Number from String Excel
- Evaluate Formula in Excel
- Find Duplicates in Excel
- Finding Links in Excel
- Filter Shortcut in Excel
- Formatting in Excel
- Format Numbers to Millions & Thousands in Excel
- Format Phone Numbers in Excel
- Formula Errors in Excel
- Fractions in Excel
- Frequency Distribution in Excel
- Group in Excel
- Group Worksheets in Excel
- Group Columns in Excel
- Hide Formula in Excel
- Hiding a Column in Excel
- Highlight Every Other Row in Excel
- Highlight Duplicates in Excel
- How to Create a Formula in Excel?
- How to Create an Excel Spreadsheet?
- How to Add Text in Excel Formula?
- How to Create Dashboard in Excel?
- How to Copy Sheet in Excel?
- How to Delete Pivot Table?
- How to Calculate Percentage Increase in Excel?
- How to Multiply in Excel Formula?
- How to Unhide Columns in Excel?
- Insert Date in Excel
- Insert Calendar in Excel
- Import Data into Excel
- Insert Comment in Excel
- Insert Hyperlinks in Excel
- Insert Multiple Rows in Excel
- Insert Row Shortcut in Excel
- Insert New Worksheet in Excel
- Insert (Embed) an Object in Excel
- Insert Image in Excel Cell
- Insert Page Break in Excel
- Line Breaks in Excel
- Linear Interpolation in Excel
- Leading Zeros in Excel
- Last Day of the Month in Excel
- Logical Operators in Excel
- Lookup Table in Excel
- Mortgage Calculator in Excel
- Moving Average in Excel
- Not Equal to in Excel
- Numbering in Excel
- Name Manager in Excel
- Page Numbers in Excel
- Page Break in Excel
- Personal Budget Template in Excel
- Project Management Template in Excel
- Percentage Difference in Excel (Increase / Decrease)
- Pivot Table Calculated Field & Formula
- Pivot Table Sort
- Pivot Table From Multiple Sheets
- Print Comments in Excel
- Print Excel Gridlines
- Print in Excel
- Print Preview in Excel
- Print Area in Excel
- Print Titles in Excel
- Print Labels From Excel
- Project Timeline in Excel
- Protect Sheet in Excel
- Ratio in Excel Formula
- Random Numbers in Excel
- Randomize List in Excel
- Refresh Pivot Table in Excel
- Relative References in Excel
- Remove Blank Rows in Excel
- Remove Duplicates in Excel
- Remove Duplicates from Excel Column
- Remove Hyperlinks in Excel
- Remove Space in Excel
- Remove Leading Spaces in Excel
- Remove Watermark in Excel
- Row Limit in Excel
- Rows and Columns in Excel
- Rows to Columns in Excel
- Row Header in Excel
- Search in Excel
- Search For Text in Excel
- Share an Excel Workbook
- Shortcut to Merge Cells in Excel
- Show Formula in Excel
- Split Cells in Excel
- Separate Text in Excel
- Strikethrough in Excel
- Strikethrough Text in Excel
- Sum by Color in Excel
- Subscript in Excel
- Superscript in Excel
- Themes in Excel
- Timesheet Calculator in Excel
- Top 20 Keyboard Shortcuts in Excel
- Unmerge Cells in Excel
- Uppercase in Excel
- Word Count in Excel
- Word Cloud in Excel
- Watermark in Excel
- Weighted Average in Excel
- Wildcard in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- VBA (162+)
Autosave in excel is a function/facility used to automatically save the changes or progress of work. This will help us to reduce the impact of risk in data loss in case of any crash situation in the system.
Autosave in Excel (Table of Contents)
AutoSave in Excel
Excel has an inbuilt feature which allows us to configure when excel needs to automatically save our workbook in certain stipulated time, the time we can provide is from 1 min to 120 mins range, the input for time provided should be in the whole number, we can find this feature in the options tab under the save section, if we input the time as 5 minutes excel will automatically save our workbooks in every five minutes.
We may lose a lot of time and energy if we don’t have the “Autosave” option is turned on in Excel. Excel will save the data on periodically (time can be mentioned in excel autosave options).
How to Autosave in Excel?
Below are the examples of how to autosave files in excel.
Example #1 – Autosave Through Excel Options
Usually, Autosave is enabled in Excel by default. Let’s see how to Turn on Autosave options in Excel.
- Step -1: Go to the “File” menu. Click on “Options”
- Step -2: Excel options will pop out with a lot of options to manage as per our necessity. Click on the “Save” option – This will take us to customize the workbooks that are saved.
- From this window we can see the “Save AutoRecover information every __ minutes” is enabled. This is where we are notifying excel to save the workbook for every n minutes (n could be any number which represents no.of minutes in time). By default, Excel will take 10 minutes to perform AutoRecover but we can change this time as per our requirement such as 1,2,3 minutes and so on.
- If you enable it and couldn’t able to save then it will be stored in this path “C:\Users\aa\AppData\Roaming\Microsoft\Excel\” (this path varies for everyone as their recover
excel autosave location will be different. I request all to check for this autosave location in Excel options – Save.
We can also change the folder to save the backups by entering a different path into the “AutoRecover file location”.
- We can select a certain format when we are saving our workbooks automatically by selecting the format from the list of excel formats that are available.
By default, the format would be “Excel Workbook (*xlsx).” as this was used by most of the users. And also make sure we turn on the “Keep the last autosaved excel version if I close without saving”.
- We also can avoid saving the workbooks in one drive by enabling “Save to Computer by default” as follows:
Till now we had learned how to turn on autosave in excel, time to be given to performing the task periodically and many other features that we got.
- Now, let’s see how to recover the file which is got auto saved. As you can observe the file path that we had given in “AutoRecover file location”, copy the path.
- Now, open the Microsoft Explorer, in the top of the bar we should paste the path that we had copied from the “AutoRecover file location” and then press ENTER.
- A window with files & folders that are auto recovered will be displayed. From this window, we can click on the file that we want to be recovered and then you can keep the changes and save the workbook with a new name. Once you enter the path, the below window will pop out.
From here we can recover the files which are not saved and our work & time doesn’t go in vain by enabling the autosave in excel.
Example #2 – Turn on Autosave by Visual Basic Application (VBA)
Let’s see how can code using Excel Macro will help us to perform autosave in excel workbook.
Open “Visual Basic Editor” from the developer tab in your excel as below.
As when we click on the “Visual Basic”, we can visualize a VBA editor getting pop out. This where we have to write code to perform the autosave operation.
Here we are not going to create any module for our operation to perform as this is an “Event” where we are going to write a macro. An event is anything like if we open a workbook then it will be considered as an event, similarly, if we made changes in the workbook then it is also an event, closing the workbook is also an event and so on.
For the autosave operation, we assume “closing the workbook” as an event. Open “ThisWorkbook” which is on our left side of the page and start writing a macro.
As we open the “Thisworkbook”, we can see the “General” and change it to “Workbook” as follows.
As when we change to a workbook, It gives an option to write a macro in an event “Workbook_Open()”. There is a list of declarations that we can use to create an event on our right side. Here we are going to perform a task for autosave in excel so we have to change the event to “Beforclose”.
Select “BeforeClose” and start writing the code for autosave in excel.
“ThisWorkbook.Save” will automatically save the workbook and save it as a macro-enabled workbook to run the code as below:
Save this workbook as a macro-enabled and close the workbook. Then we can observe that display alert asking for save or don’t save won’t get pop out but some other warning alert will pop out which is as below:
Once you click on Ok, the workbook with changes will get autosaved. We can also disable this alert by using some code in VBA which saves a workbook automatically in a simple way.
Let’s see how it works:
These warning messages will come through an application so we take “Application.DisplayAlerts = False”. This means any sort of display alert will not pop out once this line is included in the code. But it also important to include a line of “Application.DisplayAlerts = True” as this helps when something important display alert to pop out.
Now try to make changes and close the workbook, we can observe that none of the display alerts will pop out but changes will get saved. This operation will help us in order to save our work though we unexpectedly close the workbook without saving it.
Things to Remember about AUTOSAVE in Excel
- Autosave in Excel is a splendid feature which saves time and data by saving it on a periodic basis.
- As once we enable the autosave in Excel then we can’t close without saving which may mislead though we don’t want to save the data actually.
- Autosave in Excel always monitors the user’s work and updates the changes in content to share point or one drive.
- It also allows multiple people to edit the document simultaneously.
This has been a guide to what is Autosave in Excel File. Here we discuss how to turn on Autosave in Excel using Excel Options and VBA (Visual Basic Application) along with examples. You may also look at these useful functions in excel –