The file format and extension dont match | Microsoft Excel | FIX TUTORIAL
ฝัง
- เผยแพร่เมื่อ 28 ก.พ. 2023
- This Microsoft Excel notification appears when opening a Microsoft Excel file. Selecting Yes at the notification resumes launching the Microsoft Excel file but does not fix the issue.
Registry Path: HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\15.0\Excel\Security
Open the Run window, by pressing the Windows key + R
Type regedit, then select OK
In the Registry Editor window, go to the Registry Path mentioned above
Right-click in the blank section on the right, then select New
Select DWORD (32bit) Value
Name the new entry: ExtensionHardening
Set the Hexadecimal value to 0
Voila. Your files should now launch without this error
To use in Command Prompt batch file:
(Copy the text below and paste into notepad, save the notepad .txt file as .bat)
REG ADD "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\15.0\Excel\Security" /v "ExtensionHardening" /t REG_DWORD /d 0
Please leave a comment if you were unable to resolve your issue using this method. - แนวปฏิบัติและการใช้ชีวิต
Perfect solution! Couldn't open *.xls files in Excel without redundant warning and now I can! Thanx.
Happy to assist bra, take care👍
Thanks a loooot friend, those extensions were headache, may God reward you what's best for you good man 🙂
You very welcome. I know how irritating this issue was for me, so glad i could help. take care.
Thankyou for helping
Pleasure, this was so irritating lol, had to find a fix
I have converted xlsx to csv but when i try to open that file i am facing the same issue. I tried this way also but not working. Can you pls provide more solutions?
Ok, have you tried restarting the pc after the change?
@@techodsg no. Let me try and will let you know. Thanks
Problem not fixed
Please provide more detail regarding your issue