THE FILE FORMAT AND EXTENSION OF “FILENAME

“The tệp tin format & extension of” document “don’t match” error prompt when the user trying to open certain files in Microsoft Office especially Microsoft Excel. All previously saved data will be gone if cliông xã on the Yes button.

Bạn đang xem: The file format and extension of “filename

*
How to Fix "The file format và extension of" Microsoft Office Document Don’t Match" width="747" height="272" /> How to Fix “The tệp tin format và extension of” Microsoft Office Document Don’t Match

Content Summary

Solution 1: Change File Extension Manually Solution 2: Unblochồng at File Properties level Solution 3: Open via 3rd Party Equivalent Software Solution 4: Disable Protected View Solution 5: Disable Add-ins Solution 6: Suppressing Warning Message using Registry Key

Solution 1: Change File Extension Manually

Step 1: xuất hiện File Explorer > View tab > Chechồng File name extensions option.

Step 2: Right-click on the tệp tin & choose Rename from the context thực đơn.

Step 3: Modify the extension to .xls, .xlsx or .xlsm, và attempt to lớn open the Exel tệp tin after each rename.

Solution 2: Unblochồng at File Properties level

Step 1: Right-cliông xã the tệp tin & choose Properties from the context thực đơn.

Step 2: Select the General tab then scroll down to lớn the Security section & clichồng the Unblock button.

Solution 3: Open via 3rd Party Equivalent Software

Step 1: Download the Full installation of OpenOffice.

Step 2: Double-cliông chồng the installation executable và follow the on-screen prompts khổng lồ complete the installation.

Step 3: After OpenOffice Calc was installed, right-clichồng on the tệp tin that you’re having issues with và choose xuất hiện with > OpenOffice Calc.

Solution 4: Disable Protected View

Step 1: Open Microsoft Excel > File > Options.

Step 2: Select the Trust Center tab > Trust Center Settings.

Xem thêm: Công Thức Viết Hoa Chữ Cái Đầu Trong Excel Hàm Proper, Cách Viết Hoa Chữ Cái Đầu Trong Excel

Step 3: Select Protected Views, uncheck all Protected View condition option then clichồng Ok lớn save sầu the changes.

Step 4: Restart Microsoft Excel.

Solution 5: Disable Add-ins

Step 1: Hold CTRL key and clichồng on application icon till it asks you for Safe mode confirmation.

Step 2: If the problem does not happen again, then start application normally và disable add-ins one by one và start application again every time you disable an add-in to lớn determine the culprit add-in.

Step 3: To disable the add-in, go lớn File > Options > Add-ins > Click on Go button beside Manage: Excel Add-ins > Untick the Add-ins to disable and tick lớn enable them.

Solution 6: Suppressing Warning Message using Registry Key

Step 1: Press Windows + R lớn open the Run dialog box.

Step 2: Type regedit and press Enter to lớn open Registry Editor. If the UAC (User Account Control), click Yes to grant administrative privileges.

Step 3: Go to lớn the following location: HKEY_CURRENT_USERSoftwareMicrosoftOffice*X*ExcelSecurity

For Excel 2007: HKEY_CURRENT_USERSoftwareMicrosoftOffice12.0ExcelSecurityFor Excel 2010: HKEY_CURRENT_USERSoftwareMicrosoftOffice14.0ExcelSecurityFor Excel 2013: HKEY_CURRENT_USERSoftwareMicrosoftOffice15.0ExcelSecurityFor Excel 2016: HKEY_CURRENT_USERSoftwareMicrosoftOffice16.0ExcelSecurity

Step 4: Right-click on an empty space and select NEW > Dword (32-bit) Value.

Step 5: Name it ExtensionHardening, double-click on it and mix the Base lớn Hexadecimal & the value khổng lồ 0.

*
Add ExtensionHardening registry key

Step 6: Cđại bại the Registry Editor & restart the computer.

Source: IBM Support > “The file you are trying to open … different format than specified by the file extension” when running Standard Reports to XLS format, using Excel 2007 (or later)


Post navigation


Next Post Next post: Visual Studio Community Edition “Your license has expired” or “Your evaluation period has ended”