Quick Fixes to Repair Microsoft Excel 2013/2016 Content related error

Summary: The blog outlines some quick tips to fix ‘We found a problem with some content’ error in Microsoft Excel 2013/2016. It explains manual procedure to resolve the error and also suggests an automated tool to perform the repair process to retrieve all possible data from a corrupt workbook.

Sometimes, when opening an MS Excel file, you may receive an error message that reads:

“**We found a problem with some content in ‘filename.xlsx’. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.**“

Figure 1 – Excel ‘found a problem with some content’ Error Message

What Causes ‘We Found a Problem with Some Content’ Error?

There is no clear answer as to what results in the Excel error – ‘**We found a problem with some content in <filename.xlsx>**’. However, based on some user experiences, it appears that the error occurs due to corruption in an Excel workbook. It may turn corrupt when:

• You try opening the Excel file saved on a network-shared drive.
• A string is added in a cell in Excel, instead of a numeric value.
• Text values in formulas exceed 255 characters.

How to Resolve ‘We Found a Problem with Some Content’ Error?

Follow these tips to fix the Excel error:

IMPORTANT! Before you follow the tips to resolve the Excel error, keep these points in mind: Make sure you have closed all of the opened Excel workbooks. Try restoring Excel file data from the most recent backup copy. If you don’t have a backup copy, make a copy of the corrupt Excel file and perform repair and recovery procedures on that backup copy.

Tip #1: Repair Corrupt Excel File

File Recovery mode is a native Excel recovery utility that automatically opens whenever any inconsistencies are found in the worksheet. If Microsoft doesn’t detect any issue or fails to open the File Recovery mode, you can start it manually to recover the corrupt Excel file. To do so, follow the steps below:

1. Click on the File menu, and then select Open.
2. In the Open dialog box, navigate to the folder location where the corrupt Excel file is saved.
3. Select the corrupt file, and then click on arrow sign available next to Open button to select Open and Repair option.

Figure 2 – Open and Repair Feature in Excel

1. Next, click Repair to recover maximum possible data.
2. If the repair is not able to recover the data from the workbook, select Extract Data to extract all possible formulas and values from the workbook.

If repairing the corrupt Excel file doesn’t work, you can try an Excel file repair tool to fix corruption errors. You can also try to recover data from the corrupt file manually by following the next tips.

Read this: What to do when Open and Repair doesn’t work?

Tip #2: Set Calculation Option to Manual

To make the file accessible, try setting the calculation option in Excel from automatic to manual. As a result, the workbook will not be recalculated and may open in Excel. For this, perform the following:

1. Click File, and then click New.
2. Under New, click the Blank workbook option.
3. When a blank workbook opens, click File > Options.
4. Under the Formulas category, pick Manual in the Calculation options section, and then click OK.

Figure 3 – Select Manual in Calculation options

1. Now, again click on the File menu and then click Open.
2. Navigate to the corrupt workbook, and double-click it.

When the workbook opens, check if it contains all the data. If not, proceed to the next tip.

Tip #3: Copy Excel Workbook Contents to a New Workbook

Several users have reported that they were able to fix ‘We found a problem with some content in ’ error message by copying contents from the corrupt workbook to a separate workbook. Detailed steps are as follows:

1. Open the Excel workbook in ‘read-only’ mode, and copy all its contents.
2. Create a blank new workbook and paste the copied contents from the corrupt file to the new file.

Tip #4: Use External References to Link to the Damaged Workbook

Use external references to link to the corrupted workbook. By implementing this fix, data contents can be retrieved. However, it is not feasible to recover formulas or calculated values using this solution.

Follow the steps below:

1. In Excel 2013/2016, click File > Open.
2. Navigate to the folder where the corrupt file is saved.
3. Right click the file, select Copy, and then click on Cancel.
4. Again, click on File and then New.
5. Under New option, click on Blank workbook.
6. In the cell A1 of new workbook, type =File Name!A1 (where File Name indicates the name of the damaged workbook being copied in Step 3).
7. If Update Values dialog box appears, click the corrupt workbook, and choose OK.
8. If Select Sheet dialog box appears, click the appropriate sheet, and then click OK.
9. Select cell A1.
10. Next, click Home, and then click Copy (or, press Ctrl +C).
11. Starting in cell A1, select area approximately the same size as that of the cell range that contains data in the damaged workbook.
12. Next, click Home and select Paste (or click Ctrl + V).
13. Keep the range of cells selected, click Home and then Copy.
14. Finally, click on Home, click on the arrow associated with Paste and under Paste Values click on Values.

This will remove the link to the corrupt workbook and will retrieve data. But, keep in mind, the recovered data will no longer contain formulas or calculated values.

Alternative Solution – Stellar Repair for Excel

If the above manual methods fail to fix the ‘We found a problem with some content in Excel error’, try using the Stellar Repair for Excel software to resolve this error. The software helps repair and recover corrupt Excel files in just a few clicks. It can be used on a Windows 10/8/7/Vista/XP/NT machine to repair a corrupted workbook and recover every single bit of data from all the versions of the Excel workbook.

Read this: How to repair corrupt Excel file using Stellar Repair for Excel?

Conclusion

In this blog, we discussed some possible reasons behind Microsoft Excel 2013/2016 ‘We found a problem with some content’ error. The error may occur when an Excel file becomes corrupt. You may try repairing the corrupted Excel file manually by using the built-in ‘Open and Repair’ feature. Or, try the manual workarounds to extract data from the corrupt file discussed in this post. If the manual solutions don’t work for you, using Stellar Repair for Excel can come in handy in repairing the corrupt Excel (.xls/.xlsx) file and recovering the complete file data.

Excel Repair Tool to Repair Corrupt Excel files (.XLS/.XLSX)

When to Use Stellar Excel File Repair Tool?

Unable to Open an Excel File Due to Invalid Extension?

You may face an error - “Excel cannot open the file .xlsx” in Excel 2021, 2019, 2016, etc., leading to data loss. This error occurs when you try to open corrupt Excel file or an invalid file format. Using the correct extension can resolve the issue, if there is no corruption. However, you need an Excel repair tool if the file is corrupt. Stellar Repair for Excel can repair the corrupt file and recover all objects in intact form.

Learn More

Excel File Not Opening Due to Corruption?

You cannot open an Excel file if it is corrupted. For example, opening an Excel file created in a lower version like Excel 2007 in Excel 2010 or later version can throw a corruption error message. Or, the file may open in a ‘protected view,’ not allowing any write operations. The Excel repair tool from Stellar provides a comprehensive solution to fix corrupt Excel files across all versions, including Excel 2021, 2019, 2016, 2013, and older.

Learn More

Excel Found Unreadable Content?

You may encounter an error message – “Excel found unreadable content in filename.xls”, with a message to recover the contents of the workbook. Clicking ‘Yes’ to recover the contents may lead to loss of formatting, replacement of formulas, and inconsistencies. Stellar Phoenix Excel Repair software now Stellar Repair for Excel can scan the workbook and recover its contents.

Learn More

KEY FEATURES FOR REPAIR FOR EXCEL

Software Important Capabilities

Repair Large-sized Excel Files

Stellar Repair for Excel software previously known as Stellar Phoenix Excel Repair can repair & fix corrupt Excel files of any size. It removes corruption from individual objects, fixes the damage, and restores the Excel file back to its original state. The Excel repair tool can repair multiple Excel files in a batch.
Learn More

Resolves All Excel Corruption Errors

This Excel file repair tool fixes all types of Excel corruption errors, such as unrecognizable format, Excel found unreadable content in name.xls, Excel cannot open the file filename.xlsx, file name is not valid, the Excel file is corrupt and cannot be opened, etc. It provides a comprehensive solution for fixing Excel file issues.
Learn More

Preview the Repaired Excel File

The software shows a preview of the repaired Excel file and its recoverable contents in the main interface. This functionality allows you to verify the data in your repaired Excel file, including all of its objects, before saving the file. The Excel File Recovery software helps in determining the final state of data you will receive after repairing the corrupted Excel file.
Learn More

Recovers All Excel file Objects

The software repairs the corrupt Excel file and recovers all objects, including tables, charts, series trendline, conditional formatting rules, and properties of the worksheet. The software also recovers embedded functions, group & subtotal, engineering formulas, numbers, texts, rules, etc. It recovers Excel file data in its intact form.

Reviews & Feedback

Recommendation by Microsoft MVPs

OTHER IMPORTANT FEATURES

Know your Product Better

Option to Find Excel Files

Stellar Excel repair software helps users unaware of the Excel file location to search for all the Excel files on the computer. It provides ‘Find’ option to quickly locate and list all the Excel files for repair. You can select single or multiple files from the list that you want to repair.

Stellar Toolkit for File Repair

Stellar Toolkit for File Repair provides essential tools to repair corrupt Office files via a single interface. It comprises tools like MS Excel Repair, MS Word Repair, MS PowerPoint Repair, and PDF Repair to fix corrupt documents while maintaining the original file format.
Learn More

HOW TO USE STELLAR REPAIR FOR EXCEL

Screenshots & Video

PRICING

Choose The Best Plan

Excel Repair

Repairs corrupted Excel files with 100% integrity.

• Repairs XLS, XLSX, XLTM, XLTX, and XLSM files
• Repairs multiple Excel files
• Previews the repaired file
• Supports Excel 2021 & older versions

File Repair Toolkit

Repairs corrupted Excel, Word, PowerPoint, & PDF files.

• Repairs XLS, XLSX, XLTM, XLTX, and XLSM files
• Repairs multiple files
• Previews the repaired file
• Supports Excel 2021 & older versions
• Repairs .DOC & .DOCX files
• Repairs .PPT, .PPTX, & .PPTM files
• Repairs corrupted PDF file

Best Seller

File Repair Toolkit Technician

Repairs corrupted Excel, Word, PowerPoint, & PDF files up to 3 systems.

• Repairs XLS, XLSX, XLTM, XLTX, and XLSM files
• Repairs multiple files
• Previews the repaired file
• Supports Excel 2021 & older versions
• Repairs .DOC & .DOCX files
• Repairs .PPT, .PPTX, & .PPTM files
• Repairs corrupted PDF file

CUSTOMER REVIEWS

You’re in Good Hands

AWARDS & REVIEWS

Most tested. Most awarded

DATA SHEET

Technical Specifications

About Product

Stellar Repair for Excel

USEFUL ARTICLES

Product Related Articles

How do I repair multiple Excel files by using Stellar Repair for Excel software?

After launching the software, click Select File button in the Home tab. Next, click Browse and select the checkbox against all the Excel files you need to repair. Then, click the Repair button to start repairing all the Excel files.

Learn More

How do I see the Preview of repaired Excel file using the Demo version of the software?

Browse and select the file(s) to repair. The software will start scanning the Excel files once you click the Repair button. Next, it will display the files in the left pane. You can preview their contents in the right pane.

Learn More

How do I find the recovered Excel file?

The software saves the repaired file with the prefix “Recovered” at the user-specified location. You can find the recovered file using the Search box utility in the taskbar.

Learn More

Start Using Stellar Repair for Excel Today

• Trusted by Millions of Users
• Awarded by Top Tech Media
• 100% Safe & Secure to Use

Free download to scan and preview all recoverable Excel data.

How to Repair Corrupt Excel Workbook?

Summary: Corruption in an Excel workbook could lead to data loss. This blog outlines the possible reasons behind corrupted workbook and describes how to repair the workbook manually and using an Excel repair tool.

Is your Excel behaving differently, for instance, stops responding or freezes? Or have you encountered a warning or an error message indicating corruption in the Excel workbook?

Figure 1 - Corruption Warning in Excel: The corrupt workbook cannot be opened or repaired

Figure 2 - Excel File Corruption Message

In any of these situations, you won?t be able to open your Excel workbook.

TIP! If you?re unable to open an Excel workbook, it does not necessarily mean that the workbook is corrupt. Try a few workarounds to resolve the issue, like disabling the ?Protected View Settings?, disabling add-ins, or moving the workbook to another drive.

You will need to repair the corrupted Excel workbook to make it usable. Before discussing the repair methods, let?s first look at the possible reasons behind file corruption.

To jump to methods to repair the workbook, click here .

Possible Reasons behind Corrupted Excel Workbook

• Large size of a workbook: A workbook containing lots of information or objects like images, shaded cells, or other visual representations is prone to corruption.
• Unexpected system shutdown or power loss: If you haven?t saved your Excel file, abrupt system shutdown or power failure can corrupt the data and render the file inaccessible.
• Bad sectors on storage media: Accumulation of bad sectors on storage media on which Excel files are saved is another reason that may lead to Excel file corruption.

Other common reasons causing Excel file corruption are virus attack, network errors, etc.

Methods to Repair Corrupted Excel Workbook

Note: Repairing the corrupt workbook may result in data loss. And so, it?s recommended to back up the workbook before attempting to repair the file.

Method 1 ? Repair the Excel Workbook Manually

Use the Excel ?Open and Repair? feature to repair your corrupt workbook manually. Here?s how:

Step 1: In Excel, click the File tab and then click Open.

Step 2: Select the corrupt Excel file, click the arrow button next to the Open button and then select Open and Repair.

Figure 3 - Excel Open and Repair Feature

Step 3: In Microsoft Excel dialog box that opens, click Repair to begin repairing your corrupt workbook.

Figure 4 - Repair the Microsoft Excel File

Note: If the Excel repair process fails, repeat Steps 1 till 3 and click the ?Extract Data? button. This will help you extract values and formulas from the corrupted workbook.

Performing these steps will repair your Excel file. If the issue persists, skip to the next method.

Method 2 ? Use Excel File Repair Software

If the above method failed to fix corruption in the workbook, use Excel file repair software to repair your workbook quickly. This Excel repair tool is purpose-built to help users repair large-sized Excel files (.xlsx and .xls) in just a few clicks. Also, it helps recover all the data from the corrupted workbook while preserving the cell formatting and worksheet properties.

Steps to Repair Corrupt Excel File Using the Software

Step 1: Download, install, and open Stellar Repair for Excel software.

Free Download for windows ](https://tools.techidaily.com/stellardata-recovery/repaire-for-excel/ )

Step 2: Click Browse to select your corrupted .xlsx or .xls file. If you are not aware of the file location, click Search to locate and select the file.

Figure 5 - Select Corrupt Excel Workbook

Step 3: Once the file is selected, click Repair.

Step 4: A preview of recoverable workbook data gets displayed.

Figure 6 - Preview of Recoverable Excel Workbook Data

Note: You will need to activate the licensed version of Stellar Repair for Excel software for saving the repaired file. Once activated, proceed with the steps below to save the repaired file.

Step 5: Click Save File on the File menu. This will open a Save File dialog box with options to save the repaired .xlsx/.xls file at default or new location. After choosing the appropriate option, click OK.

Figure 7 - Save Repaired Excel File

The repaired file will get saved at the selected location.

Key Features of Stellar Repair for Excel Software

• Repairs severely corrupt Excel file and recovers pivots, pivot tables, conditional formatting rules, chart, chart sheets, etc.
• Can repair multiple Excel files in a batch simultaneously
• Can handle all types of Excel file corruption errors, like ?Excel found unreadable content in filename.xls?, ?Excel cannot open the file filename.xlsx?, etc.
• Supports repairing corrupt workbooks of Excel 2019, 2016, 2013, 2007, 2003, and lower versions.

End Note

If your Excel workbook has turned corrupt, try using the methods discussed in this blog to repair the workbook. Once it is repaired, you must follow preventive measures to avoid your Excel file from getting corrupt. Some of these measures are as follows:

• Reduce the size of your workbook by:

  • Removing unused data
  • Saving images at lower resolutions
  • Avoid saving pivot table cache

• Turn on the ?AutoRecover? and ?AutoSave? features in Excel

How to Fix Excel Run Time Error 1004

Summary: Run-time errors are windows-specific issues that occur while the program is running. This blog will teach you how to fix Excel run-time error 1004. In addition, you’ll learn about an Excel repair tool that can help fix the error 1004 if it occurs due to corruption in Excel files.

VBA (Microsoft Visual Basic for Application) is an internal programming language in Microsoft Excel. Sometimes, when users try to run VBA or generate a Macro in Excel, the Run-time error 1004 may occur. This error may occur due to the presence of more legend entries in the chart, file conflict, incorrect Macro name, and corrupt Excel files. In this blog, we have discussed the reasons and shared some solutions to resolve run-time error 1004.

Why This Error Occurs?

The run time error 1004 usually occurs when you run a VBA macro with the Legend Entries method to modify the legend entries in the MS Excel chart. It happens when the chart contains more legend entries than the available space, macro name conflicts, corrupt Excel files, or data-types mismatch in the VBA code.

Ways to Fix Excel Run-Time Error 1004?

Try the below workarounds to fix Excel run-time error 1004:

Create a Macro to Reduce Chart Legend Font Size

Sometimes, Excel throws the run-time error when you try to run VBA macro to change the legend entries in a Microsoft Excel chart. This error usually occurs when Microsoft Excel truncates the legend entries because of the more legend entries and less space availability. To fix this, try to create a macro that shrinks/minimize the font size of the Excel chart legend text before the VBA macro, and then restore the font size of the chart legend. Here is the macro code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

VBCopy
Sub ResizeLegendEntries()

With Worksheets("Sheet1").ChartObjects(1).Activate
      ' Store the current font size
      fntSZ = ActiveChart.Legend.Font.Size

'Temporarily change the font size.
      ActiveChart.Legend.Font.Size = 2

'Place your LegendEntries macro code here to make
         'the changes that you want to the chart legend.

' Restore the font size.
      ActiveChart.Legend.Font.Size = fntSZ
   End With

End Sub
Note: Make sure you have an Excel chart to run the code on the worksheet.

Uninstall Microsoft Work

You may encounter a run-time error 1004 in Excel version 2009 or older versions due to conflicts between Microsoft works and Microsoft Excel. This error usually occurs if your system has both Microsoft Office and Microsoft Works. Uninstalling one of them will fix the issue. Try the below steps to uninstall Microsoft Work:

• First, open the Task Manager using the shortcut CTRL + ALT + DEL altogether
• The Task Manager window is displayed.

• Click the Process tab, right-click on each program you want to close, and then click End Task.
• Stop all the running programs.
• Open the Run window and type appwiz.cpl to open the Programs and Feature window.

• Search for Microsoft Works and click Uninstall.

Try Deleting GWXL97.Xla File

The Add-ins files with .xla extension in MS-EXCEL is used to provide additional functionality to Excel spreadsheets. Sometimes, deleting the GWXL97.XLA file fixes the run-time error. Here are the steps to delete this file:

• Make sure you have an Admins rights, open the Windows Explorer
• Follow the Path C:\Programs Files\MSOffice\Office\XLSTART.
• Find and right-click on the GWXL97.XLA file
• Click Delete.

Change Trust Center Settings

Sometimes, run-time errors might arise because of incorrect security settings. The Trust Center settings help you find the Privacy and security settings for Microsoft Excel. Follow the below steps to change the Trust center settings:

• Open Microsoft Excel.
• Go to File > Options.
• The Excel options window is displayed.
• Choose Trust Center, and click Trust Center Settings.
• Tap on the Macro Settings tab, and select Trust access to the VBA project object model.

• Click OK.

Run Open and Repair Tool

The Runtime error also arises when MS Excel detects a corrupted worksheet. It automatically begins the File recovery mode and starts repairing it. However, if the Recovery mode fails to start, use the Open and Repair tool with the below steps:

• Click File > Open.
• Click the location and folder with a corrupted workbook.
• In the Open dialog box, choose the corrupted workbook.
• Click the arrow next to the Open tab, and go to the Open and Repair tab.
• Click Repair.

You can also opt for Stellar Repair for Excel if the Microsoft Excel’s built-in tool cannot fix the error.

Use Stellar Repair for Excel

Stellar Repair for Excel is a professional software for repairing damage. xls, .xlsx, .xltm, .xltx, and .xlsm files and recovering all its objects. Here are the steps to fix the error using this tool:

• First, download, install, and run Stellar Repair for Excel.
• Click the Browse tab on the interface window to choose the corrupted Excel file you need to repair.
• Click Scan. You will see the scan progress in the scanning window.
• Click OK.
• The tool can let you preview all the recoverable Excel file components including tables, pivot tables, charts, formulas, etc.
• Click Save to save the repaired file.
• A Save File dialog box will appear with the below two options:
• Default location
• New location
• Choose a suitable option.
• Click the Save option to repair the Excel file that you have chosen.
• Once the repair is complete, it will display a message “File repaired successfully.”
• Click OK.

Conclusion

Now you know the Excel run-time error 1004, its cause, and solutions. Follow the workarounds discussed in the blog to rectify the error quickly. However, Stellar Repair for Excel makes your task of removing run-time errors easy. It’s a powerful software to fix all the issues with Excel files. Also, it helps in extracting data from the damaged file and saves it to a new Excel workbook.

Recover Corrupted Excel File 2007, 2010 | Easy Methods

There are several reasons that can cause Microsoft Excel workbooks to turn corrupt, such as virus attack, bad sectors on a drive on which Excel file is saved, system shutdown without properly closing the Excel application, etc.

Corruption in an Excel workbook can result in data loss or render the workbook inaccessible. Fortunately, Excel automatically starts recovery upon opening a corrupted Excel file. But, if it fails, you can manually repair the file or extract data from the corrupt file.

Quick Solution: Performing 2007, 2010 Excel repair or recovery process manually can be time-consuming. Also, manual workarounds to recover corrupt Excel workbook does not guarantee recovering the complete workbook data. Use Stellar Repair for Excel software to repair single or multiple Excel (XLS/XLSX) files in 3 simple steps. The software also helps recover the Excel file, keeping the data intact.

How to Fix Microsoft Excel 2010 & 2007 Files Corruption?

Microsoft Excel comes with an inbuilt repair utility, called ‘Open and Repair’, that helps fix and recover corrupted Excel files.

Steps to Repair MS Excel 2010 Files Manually

The detailed steps to open and repair Excel 2010 are as follows:

• Open Microsoft Excel 2010 and click File from the main menu.

• Next, click Open.

• Browse the corrupt Excel 2010 file on your computer and select it in the Open dialog.

• Click the arrow next to the Open button and choose Open and Repair.

• Click Repair when prompted to recover data to the maximum.
• If Excel fails to repair, click Extract Data to extract values and formulas in the corrupt file.
• Excel prompts to ‘Convert to Values’ or ‘Recover Formulas’.
• Click Yes if it prompts the following error:

“The document file name caused a serious error the last time it was opened. Would you like to continue opening it?

• When Excel opens the last saved file, save it.

Once you’re able to access the last saved 2010 Excel file, try extracting the file contents.

Save Excel 2010 File in HTML Format

If you can open the Excel file, choose the HTML format to save it in filtered form. After that, close the Excel file as you have your data in the HTML file. The steps to save an Excel file in HTML format are as follows:

• Open Microsoft Excel 2010, click Save As, and then choose Web Page in the ‘Save as’ type drop-down list.
• Select the “Enable Entire Workbook” option, and then click the Save button.
• Close the Excel file and reopen your Microsoft Excel application. Browse the HTML file that you have saved.
• Click File from the main menu, and select Save As in the list.
• Type-in a different name, choose Microsoft Excel Workbook in the ‘Save as’ type drop-down menu, and then click the Save button.

With this, you would be able to access the data in the corrupt Excel file.

If the inbuilt tool fails to repair Excel 2010 file, a few methods can help you recover data from corrupted or lost workbook manually.

Steps to Repair Excel 2007 Files Manually

Follow these steps to repair a corrupted 2007 Excel file by using the inbuilt Microsoft Excel repair tool:

• Open Microsoft Excel 2007, click the Office button, and then select Open.

• In the Open dialog box that pops-up, browse and select the corrupt Excel 2007 file. Click the arrow next to the Open button and choose Open and Repair.

• Click Repair when prompted to recover as much data as you can from Excel 2007 file.

• If a repair fails, follow steps 1 till 3, and then click Extract Data to extract values and formulas from the corrupt file.
• In the window that appears, click Convert to Values or Recover Formulas to extract workbook data.

Note: The built-in Microsoft Excel 2007 repair tool may fail to resolve Excel corruption issue. Also, choosing to extract data from the workbook involves data loss risk. Using a professional Excel repair tool, however, can resolve all types of Excel file corruption errors and restore all its data.

Methods to Recover Data from Corrupt Excel 2010 & 2007 Files

If the ‘Open and Repair’ feature fails in getting your Excel 2010, 2007 file repaired, you can try retrieving the file contents by following some manual methods. However, the methods may vary depending on whether you can open a workbook or not.

Method 1 – Move Corrupt Excel File to another System

Move the corrupt Excel file to any other computer and try opening it in MS Excel 2010/2007. Doing so, may help you resolves disk or network-related errors leading to Excel file corruption.

Method 2 – Revert Unsaved Excel File to its Last Saved Version

If an Excel file turns corrupt while working on it but before saving any changes, try reverting it to its last saved version. To do so, perform the following:

• Open your Excel application, click the Office button, and then click Open from the menu.
• Browse the corrupt Excel file, click Yes when prompted to revert to its last saved version.

What if Nothing Works?

If you fail to recover a corrupt Excel 2007/2010 file, perform Excel file recovery with Stellar Excel repair software. The software is specially designed to help users fix their corrupted XLS/XLSX files quickly and easily without any technical assistance. It also helps restore all the file data to its original form.

Points to Remember

• Close all the MS Excel instances before using the software
• If the sheet you are repairing contains engineering formulas, please include ‘Analysis TooPak’ manually from Tools > Add-Ins

If you know the corrupt Excel 2007 or 2010 file location, click Browse to choose the file. Otherwise, click Search. Follow the below steps to recover data from corrupt Excel 2007/2010 file by using Stellar Excel repair tool:

• Click the Repair button to scan the file.

• Once the scanning process is complete, the software shows a preview of recoverable Excel file items.

• To save the repaired file, click the Save File option on File menu.

• In ‘Save File’ dialog box, choose to recover Excel 2007 & 2010 data to either the Default or New location. Click OK.

The repaired Excel file gets saved at the specified location.

Preventive Measures to Avoid Losing Excel File Data

The above-discussed methods might help salvage your data. But, it is recommended that you must take some preventive measures to avoid losing the data. One such important measure is backing up a copy of your workbook automatically. Doing so, will help you get back data in case the workbook is accidentally deleted or corrupted.

Steps to Create Backup Copy Automatically

You can automatically create an Excel backup copy by following these steps:

• Click Save As from the main menu of your Excel application.
• Browse to the location where the corrupt Excel 2010/2007 file is saved.

• In ‘Save As’ dialog box, click the arrow next to Tools button (given at the bottom left corner) and choose General Options.

• In ‘General Options’ box, check Always create backup checkbox, and then click OK.

With this, you instructed MS Excel to create a backup of every Excel file you create or open for work.

Conclusion

This article outlined the typical reasons resulting in a corrupt Excel 2010 or 2007 file, such as virus infection, bad sectors on drive, etc. It explained how to fix a corrupted Excel file by using the inbuilt MS ‘Open and Repair’ tool. The article also discussed methods to recover Excel files in MS Office 2010 & 2007 when the Microsoft Excel repair tool fails. Further, it explained how using a professional repair tool such as Stellar Repair for Excel can come in handy when the manual methods to repair and recover Excel 2007 and 2010 file fails. But, keep in mind, a workbook may get corrupt again. And so, make sure to automatically backup your workbook to avoid losing its data.

How to Fix ‘Sharing Violation Error’ when Saving Excel?

Summary: You may encounter the sharing violation error in Excel when you repeatedly save changes in a workbook. The error can occur due to different reasons. In this blog, we will discuss the possible reasons behind this sharing violation error and some effective solutions to fix it. If the issue has occurred due to corruption in Excel file, you can try the advanced Excel repair tool mentioned in the post to repair the corrupted file.

It is not uncommon to encounter errors while working with Excel application. One common error that Excel users face is the sharing violation error that occurs while saving an Excel spreadsheet. The complete error message says, “Your changes could not be saved to file because of a sharing violation.” When this error occurs, users won’t be able to save the changes in the file. So, it is important to fix this issue as soon as possible. But before fixing the error, let’s find out the causes behind this error.

Causes of Excel Sharing Violation Error

This error may pop up due to the below reasons:

• The file you are trying to save is corrupted.
• The Excel file is not in the trusted location.
• Sharing Wizard is disabled.
• You do not have permission to modify the Excel file.
• The Excel file is not permitted to get indexed.

Methods to Fix the Sharing Violation Error in Excel

You can move the affected Excel file to a new folder and save it with a different name. Then, see if it fixes the error. If it doesn’t help, you can try the below methods.

Method 1: Check and Change the Excel File Properties

You can get the sharing violation error in Excel if the file attribute options, such as “File is ready for archiving” and “Allow this file to have contents indexed in addition to file properties” are disabled. You can check the File Properties and enable these options to fix the issue. Here are the steps:

• Right-click on any Excel file and select Properties.

• In the Properties window, click on the Advanced option.

• In the Advanced Attributes window, select the below options under File attributes:
• File is ready for archiving.
• Allow this file to have contents indexed in addition to file properties.

• Click OK.

Note: If these options are already selected, then unselect and re-select them.

Method 2: Enable Sharing Wizard Option

The error “Your changes could not be saved to file because of a sharing violation” can also occur if the sharing wizard option is disabled on your system. You can check and enable the sharing wizard option using these steps:

• Go to your system’s Documents folder.
• Click View > Options > Change folders and search options.

• In the Folder Options window, click View.

• Under the View section, search for the “Use Sharing Wizard” option in the Advanced Settings.

• If the Use Sharing Wizard option is unselected, select it and then click OK.

Method 3: Move the Excel File to a Trusted Location

You can encounter the sharing violation error if the file you are trying to save is not in the trusted location. You can try moving the file to a trusted location by following these steps:

• In Excel, go to File and then click Options.
• Click Trust Center and then click Trust Center Settings.

• In the Trust Center window, click Trusted Locations and then click Add new location.

• In the Add new location window, select Browse to locate and choose the folder, and then click OK.

Method 4: Open Excel in Safe Mode

Incompatible add-ins can create issues in the Excel file. To check if the sharing violation issue has occurred due to add-ins, open Excel in safe mode. To do so, follow these steps:

• Open the Run window using Windows + R.

• Type excel /safe and click on OK.
• Open the affected file and then try to save the changes.
• If you are able to save the changes without any error, then it indicates add-ins are causing the issue. To fix this, you can remove the recently downloaded add-ins (if any).

Method 5: Repair the Excel File

Corruption in Excel file can also create issue while saving the changes. In such a case, you can repair the corrupted Excel file using the inbuilt utility in Excel, named Open and Repair. Follow these steps to use this utility:

• In Excel, navigate to File > Open > Browse.
• In the Open dialog box, click on the affected Excel file.
• Click the arrow next to the Open button and select Open and Repair from the dropdown.
• Click on the Repair option to recover as much data from the file as possible.

If the above utility fails to fix the corrupt Excel file, then you can use a more powerful Excel repair tool , such as Stellar Repair for Excel. This Excel repair tool can repair even severely corrupted or damaged Excel files (xls, .xlsx, .xltm, .xltx, and .xlsm). This tool can recover all the data from the corrupted Excel file, including images, chart sheets, formulas, etc., without changing the original format. It can help in fixing common corruption-related errors in Excel. You can download the software’s demo version to scan the corrupt file.

To Conclude

Above, we have discussed some effective methods to fix the sharing violation error in Excel. This error may also occur if you try to save the Excel file in an incompatible format. So, check the format and try saving the file in a compatible format. If the error occurs due to Excel file corruption, you can repair corrupt Excel file using the Open and Repair tool. If nothing works, then download a third-party Excel repair tool, such as Stellar Repair for Excel. It is an advanced tool that can fix severely corrupted Excel files. You can install this repair tool on any Windows system.

How to fix “damage to the file was so extensive that repairs were not possible” Excel error?

Summary: Unable to resolve “damage to the file was so extensive that repair was not possible” error in Excel? Read this post to discover more details about the error, possible causes, and how to rectify the error. To save time & efforts, you can also try an Excel file repair software to resolve the “damage to the file…” error in a few clicks.

When opening a workbook in Microsoft Excel 2003 or later, you may encounter an error message,

“Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted.”

The error message may also occur while exporting an Excel file. Let’s find out what causes this error and what we can do to fix it.

Reasons Behind “Damage to the File Was So Extensive That Repairs Were Not Possible” Error

Your Excel file may be corrupt, oversized, virus-afflicted, etc., which can trigger this error and make the repair impossible. Below are some common reasons.

• Large or oversized excel files hindering export
• Data restore errors
• Field length of a cell is more than 256 characters
• Software conflicts, viruses, network failure
• Unable to open files in upgraded versions
• Errors on output exceeding 64000 rows
• Limited system resources (such as RAM, internal memory)

In a nutshell, the error generally happens if Excel discovers unreadable content, which may also interrupt file saving in Excel.

How to Resolve “Damage to the File Was So Extensive That Repairs Were Not Possible” Error?

Here are a few methods you can follow to fix or resolve the Excel repair error.  

Method 1: Perform Basic Troubleshooting

When opening a corrupt workbook, Microsoft Excel automatically initiates the file recovery mode to repair the corrupt file. However, if it fails to perform automatic recovery, then follow these basic troubleshooting steps:

• This error mainly happens when you try to open the Excel file in an upgraded version.  Try to open the file in an older version of Excel. You might be able to open it.
• Try saving the file with a different file name.
• Use a different file extension to save the file.
• You can save the Excel file as HTML and then open it. However, an HTML file might not save conditional formatting.
• Close other opened applications on the system which may be causing the error.
• Select less data for export at once.
• Delete worksheets if copied from another document; for instance, delete any file or screenshots you have imported.
• Open the file on another system.

If the error persists, then use the manual method to repair a workbook using the below steps:

• Go to the “File” tab.

• Select Open and select the damaged spreadsheet from the Recent Workbooks section on the right, if listed. However, if you cannot find the file in the Recent Workbooks section, click on “Browse” and choose the corrupted workbook.

• Click the drop-down arrow on the Open tab and select Open and Repair.

Method 2: Check if exporting a Heavy File is Causing Resource Limitations in Excel

Sometimes, when you try to export an Excel sheet carrying a huge database, you may face memory errors in older Excel versions like Excel 2003. Here, you’ll have to decrease the amount of data as Excel 2003 does not permit exporting extensive data beyond a limit. However, modern versions such as Excel 2007, 2010 & 2016 allow exporting a large amount of data and utilize more RAM than the older versions.

Following are some other workarounds:

• Use a lesser number of query presentation fields to re-generate the query. Then, again re-enter those fields.
• Decrease the multi-line string field data text up to 8000 characters.

Method 3: Copy Macros and Data to Another Workbook (Empty) in an Advanced Excel version

If the issue is occurring due to version incompatibility, i.e., if the file opens easily in the older version but shows errors in the new version. You can:

Use the older version to open the file or copy the data or macros in an empty workbook of the new version of Excel.  

Copying the Macros in the Workstation

In Microsoft Excel, you can use the Visual Basic Editor to open the workbook with macro on another workbook by copying the macro. Both VBA tools and Macros appear in the Developer section of the excel file. This option is disabled by default. So first, you need to enable it.

Follow the instructions to enable it:

• Open Excel and go to File > Options.

• Click “**Customize Ribbon.**”

• Look at the right side of the pane and ensure the Developer tab is checked.

• Click OK.

Once you have enabled the Developer tab, follow the steps to copy the macro from one workbook to another:

• First, open both the workbooks- the workbook containing the macro and the workbook in which you need to copy the macros.
• Locate the Developer tab.

• Select Visual Basic to display the “Visual Basic Editor.”

• Go to the View menu in the Visual Basic Editor.

• Select Project Explorer.

• In the Project Explorer window, drag the module you need to copy to the destination workbook. For example:

Module 1 has been copied from Book2.xlsm to Book1.xlsm

Method 4- Restore the backup file

The workbook backup helps to open the corrupted or mistakenly deleted file. Sometimes, the issue can be fixed using the Recover Unsaved Workbook option in Excel. Here’s the list of steps to recover the files in Microsoft Excel:

• Go to the File tab on Excel.

• Click Open.

• Search on the top-left of the screen to click Recent Workbooks as below:

• Next, scroll down to the bottom.
• Click the “Recover unsaved workbooks” button.

• Scroll and find the lost file.
• Now double-click on the file to open.

Conclusion

“Damage to the file was so extensive that repairs were not possible” error can be fixed with the above troubleshooting methods or by using a third-party Excel repair tool, like Stellar Repair for Excel . Although There are no standard resolutions to fix the excel error as they may vary with different scenarios. In some cases, the manual methods might be time-consuming or fail to fix the error or recover the excel file. Hence, using an excel file repair tool may be the best option! It extracts data from the corrupted file and saves it to a new Excel workbook, which you can open and edit.

Also read: