Home / Excel / the file format and extension of “filename THE FILE FORMAT AND EXTENSION OF “FILENAME 11/11/2021 “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 SummarySolution 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 KeySolution 1: Change File Extension ManuallyStep 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 levelStep 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 SoftwareStep 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 ViewStep 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 ExcelStep 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-insStep 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 KeyStep 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*ExcelSecurityFor Excel 2007: HKEY_CURRENT_USERSoftwareMicrosoftOffice12.0ExcelSecurityFor Excel 2010: HKEY_CURRENT_USERSoftwareMicrosoftOffice14.0ExcelSecurityFor Excel 2013: HKEY_CURRENT_USERSoftwareMicrosoftOffice15.0ExcelSecurityFor Excel 2016: HKEY_CURRENT_USERSoftwareMicrosoftOffice16.0ExcelSecurityStep 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 keyStep 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 navigationNext Post Next post: Visual Studio Community Edition “Your license has expired” or “Your evaluation period has ended”