Several users are reporting that their Excel program keeps generating the following error message when they try to open a spreadsheet: ‘Excel found unreadable content’.You watching: Excel found unreadable content in Some affected users report that the issue only occurs with a particular document while others argue that the problem is occurring with every document that they try to xuất hiện with Excel.
Bạn đang xem: Làm cách nào để khắc phục lỗi excel excel tìm thấy nội dung không thể đọc được trong (tên tệp) '?
‘Excel found unreadable content’ error
What is causing the ‘Excel found unreadable content’ error?
We investigated this particular issue by looking at various user reports và the repair strategies that some affected users have deployed successfully lớn resolve the issue. Based on what we gathered, there are several common culprits that are known to trigger this particular issue:
Excel lacks administrator privileges – As it turns out, this particular error can occur if the user account doesn’t have administrative privileges when opening Excel. Several affected users have managed to resolve the issue by forcing excel to xuất hiện with admin privileges before trying to open the XLS file.The file is perceived as read-only – There is an old, unresolved Office bug that will sometime cause Word and Excel files khổng lồ be seen as read-only. This might kết thúc up triggering this particular error message. In this case, the solution is lớn simply move the tệp tin into a different folder to refresh the permissions.The tệp tin needs to be ‘sanitized’ – There are cases where Excel messes up the .XLS tệp tin in such a way that it either becomes unusable or it will trigger an error message every time the user tries to open it. A popular fix in this particular scenario is khổng lồ convert it lớn a different format – either directly from Excel or by using another 3rd các buổi tiệc nhỏ Office suite like OpenOffice.Visual Basic Component is missing – This particular issue can also occur if your Office installation is missing the Visual Basic component. Forcing the Ofice Installation to lớn install the Visual Basic Component has resolved the issue for a lot of afected users.Excel Cache is full – As it turns out, you might also be encountering this particular issue if Excel’s cache becomes full & cannot store the tệp tin of the lastly opened document. In this case, the solution is khổng lồ simply close all files và then reopen Excel.The file is blocked – If you’ve downloaded the excel tệp tin from the internet or you’ve recieved it via Email, your operating system might have blocked it for security reasons. If this scenario is applicable, you can resolve the issue by unblocking the file.System dosen’t tư vấn hardware acceleration – On low specification systems, this particular issue is frequently reported if the system cannot allocate enough resources to tư vấn hardware acceleration. In this case, the sfix is to access the Advanced Excel settings & disable hardware acceleration.If you’re struggling khổng lồ resolve the same error message, this article will provide you with several troubleshooting steps. Down below, you’ll find several potential repair strategies that users trying lớn resolve the same problem have successfully used.
If you want to be as efficient as possible, follow the methods in the order that they are presented – they are ordered by efficiency and difficulty.
Method 1: Opening Excel with Admin privileges
One quick fix that might circumvent the issue is to mở cửa Excel as an administrator first, and only then mở cửa the Excel file that is triggering the ‘Excel found unreadable content’ error. Most commonly, this is reported khổng lồ occur on computers in which the active user account doesn’t have admin access.
Here’s a quick guide on ensuring that Excel has admin privileges before opening the file:
Right-click on the Excel launcher và choose Run as Administrator. When prompted by the UAC (User tài khoản Control) click on Yes khổng lồ grant administrative privileges.
Running Excel as AdministratorOnce Excel is opened with admin privileges, xuất hiện the file that was previously throwing the ‘Excel found unreadable content’ error.
Opening the affected tệp tin with Admin privileges
If you’re still seeing the same error message even when Excel is opened with admin privileges, move down to the next method below.See more: đơn vị Cung Cấp hoàn toàn có thể Tính giá thành Tin Nhắn Sms Đã cần sử dụng Để Kích Hoạt Icloud
Method 2: Moving the file into a different folder
Although there’s no official explanation of why this fix is effective, a lot of users have reported that hey successfully resolve the issue just by moving the Excel tệp tin from one folder to another.
If you’re after a quick fix, simply cut & paste the file that is triggering the ‘Excel found unreadable content’ error in a different location & see if the issue is resolved.
If this workaround doesn’t resolve the issue or you’re looking for a permanent fix, move down khổng lồ the next methods below.
Method 3: Saving the tệp tin as website Page
One popular workaround that a lot of affected users have reported as a “satisfactory” resolution khổng lồ the ‘Excel found unreadable content’ error is to lớn save the tệp tin as a web Page & then xuất hiện the .html file in Excel & save the tệp tin back to a .xls format.
While this doesn’t treat the source of the issue, it’s a fast workaround if you don’t have time to spend troubleshooting the issue thoroughly. Here’s what you need to lớn work around the error message by saving the file as web Page:
Open the page that is showing the error và click Yes at the error prompt. Then, go khổng lồ File, choose Save As and click on browse. Next, type in a name for the tệp tin (next fo Filename) & select Web Page (.htm, html.) from the drop-down menu associate with Save as type. Then, hit Save to convert the tệp tin into a .html file.
Saving the Excel tệp tin as web PageOpen Excel, and go to File > Open and browse to the file that you previously converted to lớn the HTML tệp tin format & choose Open.
Opening the web page file in ExcelOnce the HTML file is opened in Excel, go lớn File > Save > Save As & save the tệp tin as Excel 97-2003 (.xls).
Converting the tệp tin back khổng lồ an XLS format
Once the tệp tin has been converted to XLS, you should no longer be encountering the issue.But in case you’re still seeing the ‘Excel found unreadable content’ error when trying to mở cửa the file, move down to the next method below.
Method 4: Installing the Visual Basic component (Office 2010/2013)
As it turns out, this particular error can occur if the Visual Basic component is missing from your Office 2010 / Office 2013 installation. Several users that have been encountering the issue with every .xlsm files that they tried to xuất hiện have reported that the issue was resolved after they forced the Visual Basic Component lớn install on their computer.
Note: Some affected users have reported that this particular issue was effective even if they already had the Visual Basic Component installed. When you choose to run VBA from your computer (as shown below), the installer will make a change on your office installation (which might resolve the issue automatically)
Here’s a quick guide on forcing the Microsoft Office installation to showroom the Visual Basic component:
Press Windows key + R to xuất hiện up a Run dialog box. Then, type “appwiz.cpl” & press Enter to mở cửa up the Programs & Features menu.Type appwiz.cpl và Press Enter to open Installed Programs ListInside the Programs & Features window, scroll down through the danh sách of applications & locate your Microsoft Office installation (Microsoft Office Office 2010 / Microsoft Office 2013).Once you manage khổng lồ locate the Office installation, right-click on it and click on Change.Changing the installation of Microsoft OfficeOnce you arrive inside the Microsoft Office setup window, choose Add or Remove Features, then click on Continue to lớn advance.
Microsoft Office thiết đặt wizardScroll through the danh mục of add-ons that can be installed on Microsoft Office & expand the drop-down menu associated with Office Shared Features. Then, right-click on Visual Basic for Applications and choose Run from My Computer.
Configuring Visual Basic for Applications lớn install on your Office installationHit Continue, then follow the on-screen prompts to complete the Microsoft Upgrade. Once the process is complete, restart your computer và see if the issue has been resolved at the next startup.See more: Cách sử dụng Hàm Nhân phân chia Trong Excel, phương pháp tính Cộng Trừ Nhân phân tách Trong Excel Đơn Giản
If you’re still encountering the ‘Excel found unreadable content’ error when trying to mở cửa an Excel file, move down lớn the next method below.
