Step 4: Now AutoSave setting will be open where a user can configure AutoSave settings, tick mark on the AutoSave checkbox, and configure the time interval you want to save the workbook for AutoRecover and select the respective file where you want to save the file. Step 3: After clicking on Options, one pop-up be open with a header as Excel Options click on Save. Let’s take the same data for this example. How to save the backup file to your choice of folder? AutoSave will save the data to the user’s located path, and he can recover the data as per requirement. Now a user can work without any tension of losing data due to an excel crash or any system issue. When a user recovers the file from the saved file, the last version of the saved workbook will be open if you closed without saving it. Then click on the OK button all the settings will be applied to the workbook.Īs we can see in the above example of an Excel AutoSave, a user can configure the time at which time interval you want to save the workbook for AutoRecover and select the respective file where you want to save the file. Step 5: Now select the Keep the last AutoRecovered version if I close without saving box to save the last saved file for the auto-recovered. Step 4: Now AutoSave setting will be open where a user can configure AutoSave settings, tick mark on the AutoSave checkbox, configure the time at which time interval you want to save the workbook for AutoRecover, and select the respective file where you want to save the file. Step 3: After clicking on Options, one pop-up will be open with the header Excel Options, click on the Save. Step 1: Open MS Excel and Click on the File tab. How to enable Excel AutoSave and save maximum work from losing it due to some power failure or something unexpected happening in Excel. Now a user can work without losing data that might happen due to an excel crash or any system issue. Step 3: After clicking on Options, a pop-up will open with a header as Excel Options click on the Save. Step 1: Open Excel and Click on the File tab. Example #1Ī user has a standalone book data of sales, income, PBDIT, and Profit details of each quarter of ABC Company.
#My excel keeps crashing and losing data how to#
Let’s understand How to Enable AutoSave in Excel with some examples. It is also useful when we accidentally close the working file. Shortcuts to Save the Excel file: We can use Ctrl + S shortcut to save the workbook manually.ĪutoSave in Excel helps us to protect our files in case of a system crash. So, there is no need to worry about losing data due to any problem rather we will lose very minimal data instead of losing it completely. As per our requirement, we can change as per our requirement, let us take an example, suppose if we are working on something that is very important and wants to reduce the time to 1 min. When we enable AutoSave mode in Excel, we can save our workbook file in a gap of every 10 minutes. I need to figure out how to fix this or we are going to have to stop using Office 365 as it is too unreliable and costing us more than it is saving us.Excel functions, formula, charts, formatting creating excel dashboard & others I have provided more powerful laptops and still have the issues. I have reinstalled Office 365, I have reinstalled the OS on a new machine then reinstalled Office 365 and still having these issues. This is tremendously frustrating and near impossible to troubleshoot. Excel somehow created links between the 2 sheets. Were completely unrelated and previously had no links to each other in them. Recently one of the people had a crash and when the document was opened back up, it had links to other cells on another spreadsheet in it. This has cost our finance department many hours of time to re-do spreadsheets that have lost much data. Sometimes saved files do not actually save and when the file is opened back up, all the changes are gone. I have a number of people in our office that have had multiple issues with Excel crashing and losing hours of work.