How to fix Excel found unreadable content

Configurare noua (How To)

Situatie

The “Excel found unreadable content” error message appears when Microsoft Excel encounters issues while trying to open a specific workbook. The complete error message states, “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.”

Upon selecting the “yes” option, you may encounter one of two scenarios. In the first scenario, Excel will attempt to repair or remove the unreadable content in the workbook. Although the file will open, data loss or inconsistencies can occur, particularly with images. In the second scenario, you will receive the error message “The file is corrupt and cannot be opened.” This indicates that the Excel file is severely damaged and cannot be accessed.

The “Excel found unreadable content” error indicates that Excel has detected problematic content within the workbook. By choosing to recover the contents, there is a chance that some data may be lost or inconsistencies may occur. The file may be so corrupted that it cannot be opened in certain cases.

Solutie

Pasi de urmat
Open Your Excel File with Admin Privileges
  1. Right-click on the Excel launcher icon and select the “Run as Administrator” option. This ensures that Excel runs with administrative privileges.
  2. A User Account Control (UAC) dialog box will appear. Click “Yes” to grant administrative privileges.
  3. Once Excel opens with admin privileges, try opening the specific file that was showing the “Excel Found Unreadable Content in .xlsx” error.
Make the Excel File ‘Read-only’
  1. Open your Excel file and click on the “File” tab.
  2. Choose the “Save” option if it’s a new document, or select “Save As” if it’s an already saved file.
  3. In the “Save As” dialog box, click on the “Tools” button and select “General Options.”
  4. In the “General Options” window, check the box next to “Read-only recommended” and click “OK.” This will set the Excel file as read-only.
  5. Open a new Excel file (blank workbook) and copy the entire data from the corrupt Excel file to this new file.
  6. Save the new Excel file with a different name or in a different location.
  7. Close Excel and reopen it.
  8. Try opening the newly saved Excel file to see if the “Excel Found Unreadable Content” error is resolved.
Try to Open Your File in Excel 2003
  1. Open the error-prone .xls file using Excel 2003.
  2. Once the file is open, click on the “File” tab.
  3. From the drop-down menu, select the “Save” option.
  4. In the “Save As” dialog box, choose the “Web Page (.html)” format as the file’s “Save as type.” Click “Save” to proceed.
  5. The data from the .xls file will now be saved in .html format.
  6. Next, try opening the saved .html file in Excel 2010/2007.
  7. Once the file is open in Excel 2010/2007, save it again with the .xlsx extension. Ensure to provide a new name for the file to avoid overwriting the original one.
Move Excel File to a New Folder
  1. Locate the Excel file that is showing the unreadable content error.
  2. Right-click on the file and select “Cut” or “Copy.”
  3. Navigate to a different folder or create a new folder where you want to save the file.
  4. Right-click in the new folder and select “Paste” to move or copy the Excel file into the new location.
  5. If you copied the file, you can try opening the copied version in Excel to see if the error is resolved.
  6. If you moved the file, open the Excel application and use the “File” tab to browse to the new folder where you moved the file. Try opening the file from there.

Moving the Excel file to a new folder may eliminate any potential file system or folder-specific issues causing the unreadable content error. Saving the file with a new name ensures that you have a separate copy to work with and reduces the chances of overwriting the original file.

Tip solutie

Permanent

Voteaza

(1 din 3 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?