![Data Disappears in Excel 2016 - How to get it back | Stellar](https://www.lifewire.com/thmb/U3vDiQ7GsjPng-Yja5bpNwc079s=/400x300/filters:no_upscale():max_bytes(150000):strip_icc():format(webp)/GettyImages-527847020-5b9edc17c9e77c0050ff9045.jpg)
Data Disappears in Excel 2016 - How to get it back | Stellar
![](/images/site-logo.png)
Data Disappears in Excel - How to get it back
Summary: You may face the issue of ‘Excel spreadsheet data disappeared’ after changing Excel file properties and formatting rows and columns. This blog discusses the possible reasons for data disappearance and the solutions to fix the issue. Also, it mentions an Excel file repair tool to retrieve the data from the file. Sometimes, while editing or formatting a cell in an Excel spreadsheet, the data may go missing or disappear. Let’s discuss in detail the reasons that may cause the ‘Excel data disappeared’ issue along with the solutions.
Probable Reasons for Data Disappearing in MS Excel and Solutions Thereof
Reason 1 – Unsaved Data
While entering data in an Excel spreadsheet, it is important to save the data at frequent intervals. Doing so prevents any unsaved data from disappearing if you lose power or accidentally click ‘No’ when prompted to save the file. Unfortunately, such a situation is quite common as users often close the file without saving the recently made changes to a spreadsheet.
Solution – Use the ‘AutoSave’ Feature
With the AutoSave feature enabled in Excel, data won’t be lost in the event of power failure or abruptly closing the Excel program. By default, Excel automatically saves the information in a spreadsheet after every 10 minutes. You can reduce the limit to a few seconds to reduce the chances of Excel file data lost after being saved.
Reason 2 – Changing Excel Format
You can save an Excel file in various formats, like spreadsheet, text, webpage, and more. However, at times, saving the spreadsheet in a different format may lead to missing data. For example, when you save a workbook to a text file format, all formulas and calculations applied to the data will be lost.
Solution – Adjust a Spreadsheet for the Changed Format
If you’re changing the format of a spreadsheet, make space for the rows and columns. Also, remove all calculations before saving the file.
Note: If the sheet is shared on multiple computers, then save the file in compatibility mode.
Reason 3 – Merging Cells
You can combine two or more cells data to make one large cell. This technique is primarily used to fit the text of a title in a sheet. If there is data in two or more cells, then only the data in the top-left cell is displayed and the data in all other cells is deleted. If the other merged cells have been populated with data after merging, the data is not featured and it does not appear even after remerging the cells.
Solution – Merge Cells inside One Column
To merge cells without data loss, combine all the cells you want to merge within a column and do the following:
- Select the cells to be combined.
- Ensure that column width is wide enough to fit the contents of a cell.
- In the spreadsheet, under the Editing group, click ‘Fill,’ and then click ‘Justify.’
- Under Alignment, click on the ‘Merge & Center’ option to center align the text. Or, click on ‘Merge Cells’.
Note: This solution works for text only. You cannot use it to merge formulas or any numerical values. If you need to combine two or more cells with formula into a single cell, try using the Excel CONCAT function .
Reason 4 – Cell Formatting
Cells and text in the cells can be displayed in different colors to make the spreadsheet simple to create and infer. You may experience data loss when you try to modify the data or change the color or size of the data. Though the information may exist, the data may show an error due to the following reasons:
- White-colored text will not show in a white-colored cell
- Large font-sized data may not appear in small-sized cell
- Calculations may show (#VALUE) error after cell-formatting
Solution – Check and Clear Formatting
Make sure to use dark-colored text on a white-colored cell. Also, resize the cell to fit the text size. Check if numbers in a cell are entered as text. If so, you need to apply a number format to the text-formatted numbers. Read more about it, from here .
What Else You Can Do to Resolve the ‘Excel Data Disappeared’ Issue?
If you can’t recover the missing Excel file data, try to repair or extract the data from the file using the built-in Excel repair tool. Follow the below steps to use the tool:
- Open MS Excel, click File > Open > Computer > Browse.
- On the ‘Open’ window, select the file you want to repair and then click on the Open dropdown.
- Select Open and Repair.
Use the ‘Repair’ option to repair the file and recover as much data as you can from the repaired file. If this doesn’t work, use the ‘Extract’ option to recover the data.
If you fail to retrieve the disappeared data from that file using the above-listed steps, opt for an Excel repair tool , like Stellar Repair for Excel. This software has a proven track record of repairing corrupt or damaged Excel files and recover all the data.
The software helps:
- Fix all corruption errors. It helps in getting back the data which has disappeared.
- Repair a single as well as multiple Excel files.
- Recover all components of XLS/XLSX files – tables, chart sheet, cell comment, image and more.
- Preserve the worksheet properties and cell formatting.
- Support the latest Excel 2019 and earlier versions.
The Excel repair software repairs the Excel file in these simple steps:
- Launch and open the software.
- Select the corrupt Excel file by using the ‘Browse’ option. If the file location is not available, then find the Excel file using the ‘Search’ option.
- Click ‘Repair’ to scan the corrupt file.
- Once the repair process is complete, verify the components of Excel file and check if the available preview shows complete data that disappeared from Excel.
- Save file at default location or preferred location.
The Excel file with all the restored data will be saved at the selected location.
Conclusion
It is better to repair the affected Excel file than suffer the loss when data or text disappears in Excel. A professional software ensures that users get back all the data in the form of a new Excel file. Stellar Repair for Excel software repairs the corrupt file without modifying the original content and file format. The software’s easy-to-use user interface lets you perform the functions without formal software training and technical expertise.
‘Unable to Save Excel Workbook’ Issue [Fix 2024]
Summary: You may unable to save your Excel Workbooks due to several reasons. Many users have reported this issue on the Tech Forums. This blog will discuss a few instances when users cannot save their Excel files. It lists the causes behind the issue and their possible solutions. It also mentions the Stellar Repair for Excel to fix the saving error if it is due to corruption in the Excel file.
It is easy to work with Microsoft Excel but sometimes, the application may create issues thereby hampering the smooth functioning of the workbook. One such issue is “unable to Save Excel Workbook”.
Let’s take a look at the issue of Unable to Save Excel Workbook
Instance 1:
In an organization, users connected to one of the servers (Windows 2008 R2) using Citrix – a Terminal Server configured with Windows 2008 R2 –and accessed their data through a File Server, also configured with Windows 2008R2. Since the connectivity to Shared Drive was established through a Terminal server, any conflict amongst the server configuration may create conflict in shared file.
This issue was discussed at length at one of the Tech Forums , where the users were unable to access their workbooks stored on the shared drive. The File menu did not work. As a result, the users were forced to save the workbook by creating quick access shortcuts or locally on the desktop. In many cases, the saving option was ruled out completely.
Instance 2:
A similar problem was reported, wherein the users received an error when saving an Excel workbook after inserting a chart in an existing workbook (previously saved) or copying values from an existing workbook. A system is configured with Windows 7 and Microsoft Office 10 configuration. The issue arises when the user is unable to save the changes after editing in a saved spreadsheet. The following message displays on the screen:
Figure: Unable to Save Excel WorkBook Issue
Further, if the user clicks ‘Continue’, the following error message is received:
“Excel encountered errors during save. However, Excel was able to minimally save your file to <**filename.xlsx**>”.
Note: This issue impacts build Version 1707 (Build 8326.2086) and later, and also only occurs with files that are stored locally, such as on the desktop. This problem does not occur if you manually enter values or insert a chart in a newly created workbook.
Plausible reasons for the ‘Unable to save Excel workbook’ Issue
- The issue was detected in Microsoft Office Professional Plus 2010 32-bit, Service Pack 14.0.6029.1000.
- Excel version on the user system may or may not match with Excel version on File server.
- The issue of ‘Unable to Save Excel Workbook’ impacts only the Build Version 1707 (Build 8326.2086) and later.
- In case of Issue 2, the problem surfaces when the user adds files, tables or charts in the locally saved excel files, such as on the desktop.
Methods to fix the ‘Unable to Save Excel Workbook’ Issue
There may be an issue with the Build version or the Registry Values settings may not be appropriate, which does not allow the Excel workbooks to save.
But, before starting to resolve the issue, verify the following:
- The location where the file is to be saved may not have enough space to save the Excel file: Check the available space and save again. You may also use the option of ‘Save As’ to save the file at a new location.
- Excel file may be a shared one where edits are not allowed by a specific user: There are restrictions attached to documents and other files shared over the network. Check for these restrictions.
- Antivirus may interrupt in during file saving: Antivirus in the system may not allow saving of the files. Request the system administrator to uninstall the antivirus and reinstall after saving.
- The file is not saved within 218 characters: If the file is not saved due to the naming issue, then check the character length and try again.
- Differences in Windows versions of the local system and those on network drive may cause excel not saved issues. Check that all the systems have the same configuration and are updated to the recently available versions.
- Excel spreadsheet is corrupt: If none of the above factors have not caused hindrance in saving the file, then there may be a probability of corruption in the Excel spreadsheet .
Once verified, look for a healthy and restorable backup. If backup is missing, resolve the issue of “Unable to open Excel File” with manual settings on local system or through a reliable Excel repair software.
Method 1: Modify Registry Entries
If multiple users are unable to access their workbooks stored on the shared drive and facing unable to save Excel file problem (see Instance 1 above), then follow the below steps:
- Go to ‘Registry Entry’. To do this, type ‘regedit’ in the Start Search box, and press ENTER
Figure: Edit Registry
- You are prompted for the administrator password or for a confirmation, type the password, or click Continue
- Locate the following registry subkey, and right-click it: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\CSC
Figure: CSC Location
- Point the cursor to New, and click Key
Figure: Create new key
- Type ‘File Parameters’ in the available box
Figure: File parameters
- Right-click Parameters, point the cursor to New, and click DWORD (32-bit) Value
Figure: File parameter (DWORD – 32 bit) value
- Type ‘FormatDatabase’, and press ‘ENTER’. Right-click ‘FormatDatabase’, and click ‘Modify’
Figure: Modify format database
- In the Value data box, type ‘1’, and click ‘OK’
Figure: Value data
- Exit ‘Registry Editor’
- Restart the system and verify if the files can be saved now
Method 2: Try Google Uploads
If the user is unable to save the changes after editing in a locally saved spreadsheet (see Instance 2 above), then follow these steps:
- Upload the unsaved Excel file to Google Docs. Ensure that the file gets converted to Google Sheets format.
- Check if all the formulae are active and working.
- Make changes to the Google Sheet and verify that all the changes are working fine.
- Use the Google Sheets export feature to download the file in Excel format.
Method 3: Resolve manually with Open and Repair
If the Excel file is found to have corruption, try out the Excel Open and Repair utility:
- Open a blank Excel File. Go to File and Click Open.
- Go to Computers and click Browse.
- Access the Location and Folder and click the arrow icon beside Open followed by Open and Repair.
Figure: Illustrates Steps to use ‘Open and Repair’ method
The Open and Repair utility is not competitive enough and may not fix corruption in severely corrupted files. Hence, if you are unable to save Excel workbook after applying the manual methods, then you can search for a useful software-based repair utility.
Method 4: Excel File Repair Software
Specifically meant to resolve Excel file corruption. Stellar Repair for Excel helps you to repair every single object including charts, tables, their formatting, shared formulae and rules and more.
- Install and Open the software and select the corrupt Excel File. You can also click the Find option if the file location is not known.
- Click Scan and allow the software to scan and repair the corrupt Excel file.
- Once repaired, the software displays the fixed file components to verify its content.
- Click Save to save the file data in a blank new file as ‘Recovered_abc.xls’, where abc.xls is the name of the original file.
See the working of the software which has been declared as a tool that provides 100% integrity and precision.
The Excel repair software takes care to save the repaired data in a new file to minimize the chances of further corruption.
Conclusion
‘Unable to save Excel file’ is a generic problem that may appear due to various reasons. In this blog post, we presented some of the actual instances reported by users on community forums.
Windows updates, the Build versions, the Service Packs of the local systems and those on the network drive must be either similar or in sync with each other. Any deviation may cause issues in accessing or saving the Microsoft files, as reported in Instance 1 is caused where user is unable to save Microsoft Excel file on the Network Drive. In case, the user is unable to save the file on network drive then the problem lies with the Registry value.
Another case is when the users receive an error while saving an Excel workbook after they insert a chart in an existing workbook or copying values from an existing workbook. This issue is known to affect build Version 1707 (Build 8326.2086) and later, and only occurs with locally stored files.
When a user is unable to save a specific Excel file, then the problem can be resolved using the manual methods or the software based utility. The mode of repair depends upon the level of corruption in Excel file.
Hence, it is suggested to analyze the nature of the problem and decide an appropriate resolution method.
Simple ways to Open Corrupt Excel file Without any Backup
Summary: The blog describes simple ways to open corrupt Excel file without any backup. It explains some manual workarounds that you can try to open the file. Also, it mentions about an Excel file repair tool that can quickly fix the corrupt file and recover data from it.
Do you have an Excel file that does not open because of corruption issue? And every time you try to open it, an error message ‘the file is corrupt and cannot be opened’ pops-up?
Excel File Corruption Message
Also, you don’t have a healthy backup of the Excel file to restore the data? If so, you can try repairing the corrupt file by using a few simple yet effective manual workarounds mentioned below.
How to Open a Corrupt Excel File without Backup?
Following are some manual methods that can help you open a corrupt Excel file:
Method 1: Repair Corrupt Excel File
When attempting to open a corrupt file, Excel automatically starts ‘File Recovery’ mode to repair the file. But, if the recovery mode doesn’t start, try Microsoft Excel’s built-in ‘Open and Repair’ feature to manually repair the file.
To use this feature, perform the following steps:
Step 1: Open a Blank workbook in Excel, and then click File > Open.
Step 2: In the Open window, browse and select the corrupt file.
Step 3: Click the arrow that is beside the Open tab, and select Open and Repair.
Open and Repair Option
Step 4: Implement one of the following:
- Click the Repair button. (This is to recover as much data as possible.)
- Click the Extract Data button. (This is to recover values and formulas from the Excel file if the repair process fails to recover the entire data.)
Excel Built-in Repair Options
If using Open and Repair does not work , move to the next method.
Method 2: Disable the Protected View Feature
Some Excel users have reported that turning off the ‘protected view’ feature in Excel helped them open the corrupt file. You can also try to disable this feature and open the file. To do so, follow these steps:
Step 1: Open a blank Excel file, click on File > Options.
Step 2: In the Excel Options window, select Trust Center, and then click Trust Center Settings.
Excel Trust Center Settings
Step 3: Click OK.
Now check if you can open the corrupt file. If not, try implementing the next method.
Method 3: Look For Automatically Recovered Excel File
If you have Excel’s AutoRecover feature enabled, you’ll have access to a copy of the Excel file corrupted or lost due to application crash, power outage, or accidental deletion.
The ‘AutoRecover’ feature saves Excel worksheets at a temporary location after a certain time interval. It saves the worksheets automatically and is turned on by default to reduce the chance of data loss.
Check if you can recover corrupted Excel file by following these steps:
Step 1: In Excel, open a Blank workbook.
Step 2: Go to File and click Options.
Figure 5 – Excel Options
Step 3: In the Excel Options dialog box, click Save, and then copy the ‘AutoRecover file location’.
Excel Options Window
Step 4: Open File Explorer window and paste the copied AutoRecover file location, and press Enter.
Step 5: A list of saved Excel files will be displayed. Choose the file you want to recover.
TIP: Use Excel’s AutoBackup feature to reduce chances of data loss, by saving a previous version of your spreadsheet automatically.
Use an Excel File Repair Software
If the above manual methods fail, repair the corrupt Excel file by using a third-party software, such as Stellar Repair for Excel**.** The software helps repair Excel (XLS and XLSX) files easily and effectively.
Read this: How to repair corrupt Excel file using Stellar Repair for Excel?
Some key features of Excel Repair software are as follows:
- Fixes all errors in the MS Excel file.
- Repairs multiple damaged Excel files in a go.
- Recovers chart, chart sheet, table, cell comment, image, formula, and sort & filter.
- Preserves properties and cell formatting of Excel worksheets.
- Previews recoverable Excel file data before saving.
- Recovers all data components from the corrupt files and saves them in a new blank Excel file.
- Compatible with Excel 2019, 2016, 2013, 2010, 2007, and lower versions.
Conclusion
You can try the workarounds discussed in the blog to open a corrupt Excel file without a backup. Disabling the protected view feature can help you open the file. If the issue persists then try repairing the corrupted Excel file using the Open and Repair utility. Although, it may not be able to fix a severely corrupted workbook. In such a case you can use Stellar Repair for Excel . It is an advanced tool that can help you repair a corrupted Excel file with 100% integrity.
Fix Cannot Paste the Data Error in Microsoft Excel
When copying and pasting the cell contents or attributes from one workbook to another, you can encounter the “Cannot paste the data” error. The error indicates that the values you are trying to paste do not match the cell format (Currency, Date, Text, etc.) used in the column. The error can occur if you are attempting to paste information into a merged cell. You can also get this error if the data you are trying to paste contains more columns than the destination worksheet can accept or if the copy area and paste area aren’t the same size.
Why you cannot Paste the Data in Microsoft Excel?
You can experience the “Excel cannot paste the data” error due to one of the following reasons:
- Locked cells
- Data size limitation
- Formatting issues
- The file size is too large
- Overloaded clipboard
- Data type mismatch
- Invalid range
- Lack of permissions
- Excel file is corrupted
- Compatibility issues
- While pasting the merged cells
Methods to Fix MS Excel Cannot Paste the Data Error
The “Microsoft Excel cannot paste the data” error usually appears when copying and pasting data within the spreadsheet. It primarily affects the copy-and-paste feature within the Excel file. However, the impact of this error may vary with the data you are working with. When this error occurs, first try restarting the Excel application. Ensure that you’ve saved all your important data before restarting the application to prevent data loss. If, after performing this basic step, you still face the issue, then try the following troubleshooting methods.
Method 1: Check and Unlock Cells in Excel
You can get the Excel cannot paste the data error if the cells you are trying to paste in the Excel file are locked. You can check and unlock the specific cells in the Excel file using the below steps:
- Go to the Home tab in your Excel file and click Format Cell Font popup launcher.
- In the Format Cells dialog box, click Protection.
- Under the Protection option, unselect the locked field and then click OK.
Method 2: Check and Fix the Cell Format
Sometimes, you can get the “Cannot paste the data” error in Excel if there is an issue with the formatting of the cells in the column (in which you are trying to paste the data). You can check whether the cell formats of the columns of the source file (from where you are copying data) match the destination file (in which you are pasting the cell data). If not, then change the cell format. Here’s how to do so:
- In the Excel file, click on the affected column heading (whose cells you need to modify).
- Navigate to the Home tab and click the General dropdown menu.
- Click on the desired cell format that matches the values you are trying to paste into the column.
Method 3: Check Copy and Paste Area Size
The “data cannot be pasted” issue can also occur if Excel detects the copy area of the range of cells is not of the same size and shape as that of the paste area. So, make sure the size of the range of cells for the paste area is same as the copied area. To ensure this, you can try the following:
- Use Upper-left Cell
You can select the upper-left cell instead of the complete range to paste.
Use Paste Special Option
You can use the Paste Special option to paste the data. To use this option, go to Home > Paste Special.
- You can choose from the different options, such as paste all, formulas, operations, Transpose, skip blanks, etc. to take control over how the data is pasted.
Method 4: Check and Unmerge Cells
The merged cells in the workbook can create discrepancies when copying and pasting data. These can create mismatch between the source and destination cell areas, resulting in errors. Make sure you are not pasting the data copied from merged cells. You can check and unmerge the cells using the below steps:
- Open the Excel file (in which you are copying data) and go to the Home tab.
- Click Merge & Center > Unmerge Cells.
Method 5: Unselect the Excel DDE (Dynamic Data Exchange) Option
Sometimes, you can get the Excel cannot paste the data error while copying and pasting data from Excel file to external data sources or applications. It usually appears if you have established DDE links between them. To resolve this, you can uncheck the “Ignore other applications that use Dynamic Data Exchange (DDE)” option. Follow the below steps to do so:
- Open your Excel file.
- Go to File > Options.
In Excel Options, click Advanced and unselect “Ignore other applications that use Dynamic Data Exchange (DDE). Click OK.
Here are some additional solutions you can try to fix the “Cannot paste the data” error in Excel
Check the Excel File Format
Sometimes, the copy and paste error can occur if you try to move data from an older version of Excel file (XLS) into a newer version file (XLSX) or vice versa. You can try to change or convert the file format to resolve the issue.
Clear Clipboard
Too many items on the clipboard can prevent you from copying and pasting the data. You can empty your clipboard by deleting all clips. To do this, go to Home and click the Clipboard option.
Change the Column’s Cell Format
You can get the “Cannot paste the data” error when the information you need to paste does not match the cell format in the column. In such a case, you can change the column’s cell format. To do this, navigate to the Home option and then click on the General menu arrow. Then, change the cell format suitable to the type of information you are trying to paste in that column.
Add Columns
The copy-and-paste error in Excel can also occur if there are not enough columns to accept the data that you are trying to paste. You can insert more columns and then try copying and pasting data. To insert additional columns, click on the column heading, click Home, and then select Insert.
Remove Incompatible Add-ins
Sometimes, incompatible or faulty add-ins can also create conflicts with Excel’s clipboard operations, leading to the error. To check if add-ins are causing the issue, open the Excel file in safe mode. In safe mode, if you are able to paste the data, then check and uninstall the incompatible Excel Add-ins.
What to do if Nothing Works?
If the above methods do not work, then corruption in the Excel file could be the cause of the “Cannot paste the data” error. In such a case, you can use Excel’s built-in Open and Repair utility to repair the corrupted file. Here’s how to use this utility to repair the Excel file:
- Open your Excel application.
- Navigate to File and then click Open.
- Click the Browse option to select the affected Excel file.
- The Open dialog box opens up. Click on the corrupted file.
- From the Open dropdown, select the Open and Repair option.
- The Excel will prompt you to choose one of the below options:
- Repair
- Extract
- Cancel
- Select the Repair option to extract maximum data from the file. If the Repair option fails, choose the Extract option to recover the data, excluding formulas and values.
The Open and Repair utility may not be able to repair your Excel file if it is severely corrupted. In such a situation, the best possible way out is to use a professional Excel repair software to repair the file. You can try Stellar Repair for Excel. It can repair highly damaged or corrupted Excel (.xls, .xlsx, .xltm, .xltx, or .xlsm) file and recover all the objects from the file by maintaining the original formatting. The tool supports 2007 and higher editions of MS Excel. You can download the demo version of the software to preview the repaired objects and verify its functionality.
Conclusion
The “Excel cannot paste the data” error in Excel can occur due to different factors. You can check and clear the clipboard, unmerge the cells, unlock the cells, and use various other methods mentioned above to troubleshoot the error. If you fail to copy and paste the data due to file corruption, then opt for an advanced Excel repair software, like Stellar Repair for Excel. It is a reliable tool that can help you repair highly damaged/corrupted Excel files. It enables you to recover all the objects from the corrupted Excel file, with complete integrity.
Summary: Recovering your unsaved Excel file on Windows 10 with some of our tested methods can truly save you a lot of time, money, and effort. Here’s how to do it!
Microsoft provides a wide range of applications to its users that cater to different purposes. Out of all the MS Office applications, Excel is considered the most used native application by several companies and individuals to store and process crucial data. Excel can also be called a go-to data analysis tool that offers great reliability, ease of use, and multiple features. But unfortunately, it’s not immune to human errors and system errors.
What if you accidentally close the Excel file without saving your work or Excel crashes suddenly? Or worse! Your system crashes without any warning and when you reboot your system, you can’t find the unsaved Excel file.
There could be different situations where you may lose access to your unsaved Excel workbook. There is no need to be anxious, though! We’ve covered some easy-to-follow DIY methods in this post to help you recover unsaved Excel files quickly.
4 Ways to Recover Unsaved Excel File
Irrespective of the circumstances, you can recover unsaved Excel files on Windows 10 using the following methods.
Method 1: Use the Search Option
If you remember the name of the Excel file, try to find it using the Search option. Following these steps:
- Go to Windows Search Box and type the name of the file.
- If you find the file there, click Open or Open file location.
- If you click Open file location, it will take you to the exact location of the file, and you’ll be able to regain access to lost/unsaved Excel file easily.
Method 2: Use AutoRecover Feature
Microsoft Excel comes with a built-in AutoRecover feature that saves copies of all open Excel files at a user-definable fixed interval. You can recover the file if you forget to save it and accidentally close it or it closes automatically due to an unexpected system breakdown or power failure. You can follow the given steps to recover unsaved Excel files with the AutoRecover feature:
- Open a new Excel file and go to File > Options.
- Then go to Save > Save workbooks.
- Next, ensure that the ‘Save AutoRecover information every’ and ‘Keep the last autosaved version if I close without saving’ option is already selected.
- Now, copy the file path given against the AutoRecover file location.
- Open the File Explorer, paste the Menu Bar file path there, and hit Enter.
- The unsaved file will appear with the .xlb extension.
- Double-click the file and choose Excel from apps to open the .xlb file.
- Finally, save the file to the desired location.
Method 3: Use the ‘Recover Unsaved Workbooks’ Option
Another way that you can choose is the ‘Recover Unsaved Workbooks’ option. To regain access to your Excel file, follow the given steps:
- Open an Excel sheet and then go to File > Open.
- Now, scroll down and click Recover Unsaved Workbooks.
- The list of unsaved files will show in the Document Recovery pane.
- Locate the file you lost and double-click on it to open.
- Finally, right-click on the version of the file you want to restore and click Save As.
And, save the file to the desired location
Method 4: Restore File with Previous Versions Utility
This feature will help you recover unsaved Excel files when you’ve saved the workbook earlier, but you end up losing access to the file due to an Excel or system crash. It’d help you save the previously saved version of your Excel file. To do so, follow the given steps:
- Open an Excel file and navigate to File > Info > Manage Versions.
- It will show the previously saved versions. You can choose the one you want to restore and click Save/Save As to store the file with a different name.
Hopefully, this blog has helped you learn how to recover unsaved Excel files. You can try any of the above methods.
FAQ
1. How can I repair a corrupted workbook?
Whenever Excel detects a corrupted workbook while opening, it automatically starts running the File Recovery mode and repairing the file. If the File Recovery mode doesn’t start automatically, you can manually repair the corrupted workbook .
Solutions to open Excel Read Only Documents
‘Excel cannot open read-only documents’ is an error message that usually appears when you try to open an Excel (XLS or XLSX) file downloaded from the Internet, email, or the network server. It may also appear when you try to open an encrypted or password-protected Excel document. In such a case, MS Excel prevents the user from making any changes to the document.
Reasons behind the “Excel cannot access ‘xxx.xls.’ The Document may be read-only or encrypted” Error
There could be several reasons that may cause the error. Some of them are as follows:
- Corrupt or damaged Excel workbook
- Incompatible or unsupported add-in
- Antivirus or malware software conflict
- Read-Only Excel file
- The file is encrypted
- File or drive read/write permissions issues
- Protected Excel workbook
- Damaged or missing MS Office (MS Excel) program files
Solutions to Open and Edit Read-Only Excel Documents
Below are a few solutions that can help you fix the ‘Excel cannot access ‘xxx.xls.’ The Document may be read-only or encrypted’ error and allow you to open and edit Excel documents.
- Remove Read-only Attribute from Excel File Properties
The ‘Excel cannot open read-only documents’ error message may appear when the Excel file property is set to read-only. To check if this is the case, follow these steps:
- Right-click on the particular Excel (xls/xlsx) document and select ‘Properties’.
- Uncheck the ‘Read-only’ attribute and then click the ‘OK’ button.
Now try to open the Excel document and check if the problem is fixed.
- Adjust Antivirus Settings
A few antivirus programs block Excel files and other Office documents by opening those in ‘read-only’ mode. In such cases, try adjusting the antivirus settings to open the Excel files normally. This will allow you to edit, modify, and save the Excel workbook without encountering the “Excel cannot access ‘xxx.xls.’ The Document may be a read-only or encrypted” error message.
- Disable Protected-View
The error may appear when you try to open an Excel file received as email attachments or downloaded from unsafe source. The file may potentially contain viruses, worms, or other types of malware that could damage the system or the server.
To safeguard the system, MS Excel opens such files in Protected View. It may also open an Excel workbook in Protected Mode when it detects a problem with the file. This security feature allows you to read or view Excel files and reduces the risks to the computer system or PC.
However, you can click File > Info and then click ‘Edit Anyway‘ to access and edit file content. You may also disable the Protected View setting via File > Options > Trust Center > Trust Center Settings…> Protected View. However, we do not recommend this.
- Renew/Activate Microsoft Office
If MS Office is in a deactivated state or its subscription has expired, the Office documents, including the Excel, could be in ‘read-only reduced functionality mode.’
In such a scenario, activate Microsoft Office or renew the Office subscription. Then open the Excel workbook and check if the problem of ‘Excel cannot open read-only documents’ is resolved.
- Check if OneDrive Storage is Full
If Excel files are saved on OneDrive with low or no storage space, you may encounter such issues with your files.
To know the amount of free space on OneDrive, follow these steps:
- On your PC, open Settings and navigate to OneDrive.
- Click ‘Sync Settings > File Storage‘ to see available space.
You may also visit onedrive.live.com, sign in to the account, and then check the available space. If there’s no space available or the drive is full, empty the storage space and see if the problem is resolved.
- Check and Update MS Office and Windows
Microsoft releases updates to fix known errors. Thus, it is critical to update both Windows and MS Office to the latest release and avoid issues, such as ‘Excel cannot access ‘xxx.xls.’ The Document may be read-only or encrypted.’
- Repair MS Office (MS Excel)
The error ‘Excel cannot open read-only documents’ may appear due to a problem with your MS Office (MS Excel) program. You can repair the MS Office program to resolve such errors. The steps are as follows:
- Open Control Panel and click Uninstall a Program link under Programs.
- Choose Microsoft Office from the list and click the Change button.
- Select Quick Repair and then click Repair to fix problems with MS Office and MS Excel. It will also restore any missing or damaged program files.
After the Repair, open the Excel workbook and check if the error is resolved.
- Check Permissions
The error message may also appear if you access an Excel workbook from a network or shared drive due to lack of write permission. Make sure you have read and write permissions assigned for the particular network drive. Alternatively, you can copy the file from the network drive and save it in your local folder to access and edit it without encountering this error message.
- Repair MS Excel File
If none of the solutions worked, the Excel workbook could be damaged or corrupt. To repair such damaged Excel workbook or spreadsheet, you can use the inbuilt ‘Open and Repair…’ option in MS Excel or install an Excel repair software , such as Stellar Repair for Excel. The software comes in handy when the Open and Repair option fails to fix the Excel workbook problems. It repairs the corrupt or damaged Excel workbook, extracts all components and content from the file with 100% integrity, and saves them in a new Excel workbook.
Conclusion
Sometimes, the ‘Excel cannot open read-only documents’ error can be resolved by a simple restart. But if it doesn’t work, you can follow the solutions discussed in this article to resolve the ‘Excel cannot open read-only documents’ issue. However, if the issue is caused due to a damaged or corrupt Excel workbook, these methods may not work. In such a case, you can use Excel’s inbuilt repair utility, i.e., Open and Repair, or install Stellar Repair for Excel software recommended by MVPs and industry experts to fix all kinds of problems with MS Excel workbooks.
How to Resolve ‘Excel found unreadable content in filename.xlsx’ Error in MS Excel?
When opening an Excel spreadsheet in MS Office 2010/2007, you may get the following error message:
“Excel found unreadable content in ‘[filename].xlsx’. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.”
On clicking ‘Yes’, you may face any of these scenarios:
Note: If you choose to click ‘No’, then open your MS Excel application and click file > Open. When the Open dialog box opens, browse and select the file showing the ‘Excel found unreadable content’ error and then choose ‘Open and Repair’ option. If this didn’t help, try using a third-party Excel repair tool to save time troubleshooting the issue and restoring the file with all its data intact.
Scenario 1: The following message may pop-up.
“Excel was able to open the file by repairing or removing the unreadable content. Excel recovered your formulas and cell values, but
. Click to view log file listing repairs errorxxx.xml.”
The message clearly states that your Excel file might open, but images may be lost and other such inconsistencies can crop up.
Scenario 2: The error is followed by another error message, like “The file is corrupt and cannot be opened“.
Watch our short video for a quick overview of the solutions to fix “Excel found unreadable content in filename.xlsx”
What Causes ‘Excel Unreadable Content’ Error?
You may encounter the ‘Excel file unreadable content’ error due to corruption of complete Excel file or corruption in certain areas (like Pivot Table, Formulas, Styles, or other objects) in the file. According to Microsoft, you may find it difficult to determine the root cause behind Excel file corruption. Corruption could occur in different scenarios, like power surge, a network glitch, copying and pasting corrupted data from another file, etc.
Also Read: How to recover data from corrupt or damaged Excel file 2010 & 2007?
Workarounds to Resolve the ‘Excel found unreadable content in filename.xls’ Error
There is no permanent solution to fix the ‘Excel found unreadable content’ error. But, following are some workarounds you can try to resolve the error.
Note: Before you try any of these workarounds, run Excel with administrator privileges and try opening the Excel file that is throwing the ‘unreadable content’ error. If this doesn’t fix the error, proceed with the workarounds below.
Workaround 1 – Try Opening the File in Excel 2003
Sometimes a problem in the current Excel version might prevent a file from opening. To resolve this error, try opening the problematic file in Excel 2003. If the file opens, save the data in a web page file format (.html) and then try opening the .html file in MS Excel 2010/2007. The detailed step-wise instructions are as follows:
- Open the .xls file in Excel 2003.
- When the file opens, click on File > Save.
- In the ‘Save As’ dialog box, choose Web Page (.html) as the ‘Save as type’ and then click ‘Save.’ Doing so will save everything from your .xls file, opened with 2003, in .html file format.
- Open the .html file in Excel 2010/2007. And then, save the file with .xlsx extension with a new name to avoid overwriting the original file.
Now, open the Excel 2010/2007 file and check if the error is fixed. If not, use the next workaround.
Workaround 2 – Make the Excel File ‘Read-only’
Try to open your ‘.xlsx’ file by making it ‘read-only’. Follow these steps:
- In Excel, click ‘File’ from the main menu.
- Select ‘Save’ for a new document or ‘Save As’ for a previously saved document in the screen that appears.
- From the ‘Save As’ dialog box, click Tools > General Options.
- Click on the ‘Read-only recommended’ checkbox to make the document read-only and then click ‘OK’.
Now open a new ‘.xlsx’ file and copy everything from the corrupt Excel file to this new file. Finally, save this file and try to open it again.
Workaround 3 – Move Excel File to a New Folder
Some users have reported that they could open their Excel file, following the ‘Excel unreadable content’ error, by simply moving the file to a different folder and saving it under a new name. You can also move the affected file to a new folder and try opening it. If this didn’t help resolve the error, follow the next workaround.
Workaround 4 – Install Visual Basic Component
At times, it is seen that installing the ‘Visual Basic’ component of MS Office 2010 resolves the ‘Excel found unreadable content 2010’ error. To do so, follow these steps:
- Navigate to Control Panel > Programs and select Microsoft Office 2010.
- Click ‘Change’ and then select ‘Add or Remove Programs’.
- Next, click the ‘plus’ sign provided next to Office Shared Features.
- Click ‘Visual Basic for Applications’. After that, right-click and choose ‘Run from My Computer’ and hit the ‘Continue’ button.
- Reboot your system when this process finishes.
Now check if the issue has been resolved or not.
What Next?
If none of the workarounds mentioned above works for you, use a professional Excel repair software, such as Stellar Repair for Excel. The software repairs corrupt MS Excel sheets without modifying their original content and formatting. In addition, it can repair single or multiple Excel (XLS/XLSX) files in a few simple steps.
Steps to Repair Corrupt Excel File using Stellar Repair for Excel Software
Install and run Stellar Repair for Excel software.
From the software main interface window, click ‘Browse’ to select the corrupt file. If you are not aware of the corrupt Excel file location, click on the ‘Search’ button.
- Click on the ‘Repair’ button to scan and repair the selected file.
- A preview window will open with recoverable Excel file data. Once satisfied with the preview result, click on the ‘Save File’ button on the ‘File’ menu to start the repair process.
- Select the destination to save the file.
- Click ‘OK’ when the ‘Repaired file saved successfully’ message appears.
The repaired Excel file will get saved at the selected location.
- Title: Data Disappears in Excel 2016 - How to get it back | Stellar
- Author: Nova
- Created at : 2024-03-11 15:19:41
- Updated at : 2024-03-14 10:58:39
- Link: https://phone-solutions.techidaily.com/data-disappears-in-excel-2016-how-to-get-it-back-stellar-by-stellar-guide/
- License: This work is licensed under CC BY-NC-SA 4.0.