How to fix Different format than specified by the file extension in Excel 2010

After upgrading to Excel 2007 or Excel 2010, an error specifying the file you are trying to open .xlsx is in a different format than specified by the file extension when you try to open an excel document:

The file you are trying to open .xlsx is in a different format than specified by the file extension. Verify the file is not corrupted and is from trusted source before opening the file. Do you want to open the file now?

The file you are trying to open .xlsx is in a different format than specified by the file extension

This error occurs when you’re trying to open an XLS file (Excel 2000-2003) with Excel 2007 or Excel 2010.

Quickest way to solve this error (registry)

The quickest way to solve this problem is to insert a registry key. This suppresses the notification.

For Excel 2007, create this key in your registry:

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security]
“ExtensionHardening”=dword:00000000

For Excel 2010, replace 12.0 for 14.0, as you can see below. Create the following key in your registry:

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Security]
“ExtensionHardening”=dword:00000000

The step-by-step instructions are as follows:

  1. Click Start, click Run, type regedit.exe and press ENTER. This will open your Registry. (Do you have Windows 7 or higher? Then run registry editor as administrator)
  2. Navigate to HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\12.0\EXCEL\SECURITY
    (or 14.0, in case of Excel 2010)
  3. In the right window, Right click and choose New -> DWORD
  4. In the Name field, type “ExtensionHardening”  (without the quotes)
  5. Verify that the data has the value “0”
  6. Click OK. Done!

I advise the steps above to solve the problem. Although it is not the safest option.

Easiest way to solve this error (GUI)

The easiest way to solve the error The file you are trying to open .xlsx is in a different format than specified by the file extension is to use the Options screen in Excel 2010. Follow these steps to disable the warning message:

  1. Open Excel 2010. Click on File, and go to Options.
  2. Click on Trust Center at the left. Then click on Trust Center Settings in the right window.
  3. In the new window Trust Center, click on Protected View on the left side panel
  4. Uncheck all options:
    1. Enable Protected View for files originating from the Internet
    2. Enable Protected View for files located in potentially unsafe locations
    3. Enable Protected View for Outlook attachments
  5. Click OK (2x). Done!

Back in 2008 I advised people to properly configure MIME Types to resolve this issue. However the issue does not occur in later versions of Office (2013, 2016 and so on). Therefor it doesn’t feel necessary anymore. This is what I stated 10 years ago: If you want a more constructive way, you should define MIME types and associate them with extensions.
Do you use a Document Management System like Sharepoint or Livelink? Try adding these:
.xls = application/msexcel
.xlsx = application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Fix The file you are trying to open .xlsx is in a different format than specified by the file extension with Group Policy

As an administrator you may want to consider the option to deploy the registry settings with a Group Policy Preference. I have not written a step-by-step guide to do this yet, but you may find this blog post about deploying WIFI-profiles with GPO Preference interesting and helpful.

5 1 vote
Article Rating
Subscribe
Notify of
guest
108 Comments
Newest
Oldest Most Voted
Inline Feedbacks
View all comments
mahender Singh

FILE OPEN IN THIS FORMAT ( I HAVE SAME PROBLEM IN EXCEL AND WORD)

c+B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B!„B

Please advise how can i Open my file.

Any software or translator or any other way to change the extention to open and recover my data.

Please reply.
Thank.

Vinod K. Chauhan

Accidentaly i delete my partitions and i use some partions recovery like minitool,partion magic 9.0 and get partitions and data back. but when i create new partiton usind partition magic9.0 suddenly current gone when i started pc again all partitions and data available but one partions nothing open my Photo,songs,videos, word file excel file what i do Plese suggest i need only Phosts and word excel file when i open excel file erreor msg is “The file you are trying to open .xlsx is in a different format than specified by the file extension. verify the file is not corrupted… Read more »

Pavani

I an trying to save the excel file through jsp. i gave below piece of code in my jsp

response.setHeader(“Content-disposition”, “inline;filename=FMI_GlobalSummary.xlsx”);

file saved but while a am trying to open that excel file it is giving the error The file you are trying to open .xlsx is in a different format than specified by the file extension. verify the file is not corrupted and is from trusted source before opening the file. Do you want to open the file now?

Please help me here- need it urgently

toine

How can you set it up for all users?

Anonymous

Use a Group Policy setting Download the 2007 Office system Administrative Template files (ADM, ADMX, ADML) and Office Customization Tool from the following Microsoft Download Center Web site: http://www.microsoft.com/downloads/thankyou.aspx?familyId=92d8519a-e143-4aee-8f7a-e4bbaeba13e7 Extract the administrative template files to a folder. To do this, follow these steps: Double-click the AdminTemplates.exe file. Accept the Microsoft Software License Terms, and then click Continue. Select a folder in which to save the extracted files, and then click OK. Click OK after the files have been extracted successfully. Open the Group Policy Object Editor. For more information about how to open the Group Policy Object Editor, visit the… Read more »

Rashid iqbal

Nice work, thanks for giving this solution.

Karu Karthi

Hi
I am working in sharepoint 2013 , exporting excel of rdlc file rendering problem..opening in PDF s working fine..after exporting into excel and trying to open the excel i am not getting the exact content..

Anonymous

awesome

Krishna

It working in the server machine. the error getting in client machine.

Hemanth kumar D

Hi,

Your solution really worked. Its an excellent trick.

Thanks,

Hemanth

Hemanth kumar D

Excellent trick to avoid warning..Thanks alot

mustafa

excellent trick

raja

Not Working………… Can Anyone Help needed Urgent………….

jayesh

what a solution dear
nice
selut

Anuradha

Excellent solution..

ayz

i already get rid the msg box but still it is on special characters. pls help

ArunKumar

Super Solutions.
its Working Perfectly..

shrikant

Excellent Solution

shrikant

Excellent Reply

Srinivas

Excellent, it is worked for me.

Sangeetha

Hi,

Good solution.Its worked Properly.Thank you.

mUEKSH

Hi I tried adding HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\12.0\EXCEL\SECURITY
but my excel documents are still corupt. any help please

srilatha M

Thank you,It was worked for me

Santos

It did work for me. However I did add it under 14.0 instead of 12.0
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Security]

Cheers

Anonymous

It did work for me. However I did add it under 14.0 instead of 12.0
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Security]

Cheers

Anonymous

Need Help!! i am looking for solution which give, eport in xlsx (2007)format in Jsp. i tried all possible ways you mentioned, but its not working.. Is there any other way, to overcome to this problem Hey hii I an trying to save the excel file through jsp. file saved but whikle a am trying to open that excel file it is giving the error The file you are trying to open .xlsx is in a different format than specified by the file extension. verify the file is not corrupted and is from trusted source before opening the file. Do… Read more »

Kajal

Hey hii I an trying to save the excel file through jsp. file saved but whikle a am trying to open that excel file it is giving the error The file you are trying to open .xlsx is in a different format than specified by the file extension. verify the file is not corrupted and is from trusted source before opening the file. Do you want to open the file now? i am workin in excel 2007,i do all changes in 12.0 but still not working,there is no 14.0,there is only 8.0 other than 12.0,but in that 8.0 there is… Read more »

riki

IT WORKED FOR BY CHOOSE THIS ONE . than”s

It did work for me. However I did add it under 14.0 instead of 12.0
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Security]

Cheers

Steven

Solution Works Perfectly.
Thanks Christian!

charisse

hi.. what you gave worked. it just remove the message box. My problem is when i always open it, with or without the “extensionHardening”, it doesn’t show anything.. what should i do?

Melly

I get to the registry part fine, but I do not have the SECURITY part. Is there another spot I could put it? Thanks!

Sundas

I was working on office 2007 file. Then my pc became turned off due to electricity problem. After this, when i turn on my pc i have lost my excel file. An xls file is appeared instead. when i tries to open it then says, “The file you are trying to open .xlsx is in a different format than specified by the file extension. verify the file is not corrupted and is from trusted source before opening the file. Do you want to open the file now?”
Please Please Please Help Me its my job’s problem.

Deepti

For people who are getting junk characters they can try removing Response.ClearHeaders(). This gives error with IIS 6

Anonymous

For people who are getting junk characters they can try removing Response.ClearHeaders(). This gives error with IIS 6

How do you remove Response.ClearHeaders()

Anonymous

Need Help!!
i am looking for solution which give, eport in xlsx (2007)format in Jsp.
i tried all possible ways you mentioned, but its not working..
Is there any other way, to overcome to this problem

Mahesh

Accidentaly i delete my partitions and i use some partions recovery like minitool,partion magic 9.0 and get partitions and data back. but when i create new partiton usind partition magic9.0 suddenly current gone when i started pc again all partitions and data available but one partions nothing open my Photo,songs,videos, word file excel file what i do Plese suggest i need only Phosts and word excel file when i open excel file erreor msg is “The file you are trying to open .xlsx is in a different format than specified by the file extension. verify the file is not corrupted… Read more »

frankreid

Thanks, This solved the problem.

Anonymous

Worked for me… :)

HM

Given registry modification solution worked for me. Thanks

sulekha

The file you are trying to open .xls is in a different format than specified by the file extension. verify the file is not corrupted and is from trusted source before opening the file.

I am getting while try to open a EXL 2003 file in 2007.Is there any other way to reslove this prob except registry change or group change policy

Anonymous

The file you are trying to open .xls is in a different format than specified by the file extension. verify the file is not corrupted and is from trusted source before opening the file.

I am getting while try to open a EXL 2003 file in 2007.Is there any other way to reslove this prob except registry change or group change policy

omar

Excellent

Muhammad Javed

hFÿÿÿÿ@À{°FØÿÿÿÿ@X|p|˜| ”•0…°Fÿÿÿÿ@X|øFÐÿÿÿÿ@è|} }0–0…øFÿÿÿÿ@è|0GÈÿÿÿÿ@p}ˆ}¨}`—0…0Gÿÿÿÿ@p}hG¸ÿÿÿÿ@ø}~P~ ™x™°„(¦P™„hGÿÿÿÿ@ø}°Gxÿÿÿÿ@H Hÿÿÿÿ@È~à~¸`ž œè›À›˜›°Gpÿÿÿÿ@H`¨œÀp°Gÿÿÿÿ@H Hÿÿÿÿ@È~ÐHÿÿÿÿ@€ €àH€ Ÿ0…¨Hÿÿÿÿ@p€ˆ€H€ Ÿ0…`êPÿÿÿÿ@ †`RPÿÿÿÿ@H xI Dear all, i did with registry file as you told you above but excel file is still showing the same issue actually i had recover that excel data and know it is not opened i got this error message when try to open it the file you are trying to open,name.xls is in a different format then specified by the file extension. verify that file is not corrupted and is from a trusted source before open the file do you want to open the file now ? some one can please tell me the… Read more »

Gunter

That was excellent, “ExtensionHardening“
it worked like a Spell

thanks

Anonymous

That was excellent, “ExtensionHardening“
it worked like a Spell

thanks

Aslam

Hi,

While opening the file we receives the content which was low level format example ” ªdÕ /1éƒO@üôâVR-D«›°‰)¿:5Ë«±Ï!œn¶h%P¹Þ.Þy¼äÞXÎàš43€x©õJÉ<ÁHl-&ð´æ)Tm á ‘Gí€=mm`„µ„ þ "….
ªdÕ /1éƒO@üôâVR-D«›°‰)¿:5Ë«±Ï!œn¶h%€P(Þ.Þy¼äÞXÎàš†Ê‡¨õJÉ<ÁHl-&~´æ)¹m á<n¸<6~Â’wýŸ{,yß+ØoåSPp:HFÝKygÆ­

any other way to open the file

nk

Hi,

Is there any other alternative rather than changing the registry?

Sam

sorry, file open but not in correct formatt

AMJ

Lovely…… I got rid of the annoying message-box :-)

Ali Ahamad

Sir,

While opening the file we receives the content which was low level format example ” ªdÕ /1éƒO@üôâVR-D«›°‰)¿:5Ë«±Ï!œn¶h%P¹Þ.Þy¼äÞXÎàš43€x©õJÉ<ÁHl-&ð´æ)Tm á ‘Gí€=mm`„µ„ þ "….

please suggest in this regard.

Thanks, Ali.

Anonymous

Sir,

While opening the file we receives the content which was low level format example ” ªdÕ /1éƒO@üôâVR-D«›°‰)¿:5Ë«±Ï!œn¶h%P¹Þ.Þy¼äÞXÎàš43€x©õJÉ<ÁHl-&ð´æ)Tm á ‘Gí€=mm`„µ„ þ “….

please suggest in this regard.

Thanks, Ali.

jambai

It works good.

Would lke to know is there any other alternative rather than changing the registry or group policy.

Thanks
Jambai

Sachin

Hi, Thanks for the post. Your solution worked!

Nikita

I was gettibg the same error, the regedit jhelps to erase the error but still the data is incorrect. It gives some corrupt junk data.
Can u help please?

Gamecock

Great fix! Thank you so much!

Mike

I love you.

Sherri

I’m having this issue with a file when I open it. Your solution looks good, but won’t it only work on my laptop? What can I do if my file is going to be opened by others on different computers?

younes

I’m having this issue with a file when I open it. Your solution looks good, but won’t it only work on my laptop? What can I do if my file is going to be opened by others on different computers?

that would be their problem and not yours.

Janet Huang 1965

Thank you so much for the fix. Worked great!

Janet

Anonymous

Not at all working>Janet

HiPlease give the proper solution

Thanks

Thank you so much for the fix. Worked great!Janet

shrishail

Hi
your solution woked.It is very nice

Brian

I was getting the error like file format is not specified after opening the 2003 macro excel file in 2007 excel. After doing the steps given above , error message is not coming but excel sheet gets disappeared after complete processing. Please advice.

108
0
Would love your thoughts, please comment.x
()
x