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?

C:\Users\Chris\Desktop\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.

117
Leave a Reply

avatar
95 Comment threads
22 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
74 Comment authors
mahender SinghVinod K. ChauhanPavaniRashid iqbalKaru Karthi Recent comment authors
  Subscribe  
newest oldest most voted
Notify of
mahender Singh
Guest
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
Guest
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
Guest
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
Guest
toine

How can you set it up for all users?

Anonymous
Guest
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
Guest

Nice work, thanks for giving this solution.

Karu Karthi
Guest

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
Guest
Anonymous

awesome

Krishna
Guest
Krishna

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

Hemanth kumar D
Guest
Hemanth kumar D

Hi,

Your solution really worked. Its an excellent trick.

Thanks,

Hemanth

Hemanth kumar D
Guest
Hemanth kumar D

Excellent trick to avoid warning..Thanks alot

mustafa
Guest
mustafa

excellent trick

raja
Guest
raja

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

jayesh
Guest
jayesh

what a solution dear
nice
selut

Anuradha
Guest
Anuradha

Excellent solution..

ayz
Guest
ayz

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

ArunKumar
Guest
ArunKumar

Super Solutions.
its Working Perfectly..

Anonymous
Guest
Anonymous

Excellent solution..

Super Solutions.
its Working Perfectly..

shrikant
Guest
shrikant

Excellent Solution

shrikant
Guest
shrikant

Excellent Reply

Srinivas
Guest
Srinivas

Excellent, it is worked for me.

Sangeetha
Guest
Sangeetha

Hi,

Good solution.Its worked Properly.Thank you.

mUEKSH
Guest
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
Guest
srilatha M

Thank you,It was worked for me

Santos
Guest
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
Guest
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
Guest
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
Guest
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
Guest

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
Guest
Steven

Solution Works Perfectly.
Thanks Christian!

charisse
Guest
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
Guest
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
Guest
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
Guest
Deepti

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

Anonymous
Guest
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
Guest
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
Guest
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 »

Anonymous
Guest
Anonymous

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
Guest
frankreid

Thanks, This solved the problem.

Anonymous
Guest
Anonymous

Worked for me… :)

HM
Guest
HM

Given registry modification solution worked for me. Thanks

sulekha
Guest
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
Guest
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
Guest
omar

Excellent

Muhammad Javed
Guest
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 solution

Gunter
Guest
Gunter

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

thanks

Anonymous
Guest
Anonymous

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

thanks

Aslam
Guest
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
Guest
nk

Hi,

Is there any other alternative rather than changing the registry?

Sam
Guest
Sam

sorry, file open but not in correct formatt

AMJ
Guest
AMJ

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

Ali Ahamad
Guest
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
Guest
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
Guest
jambai

It works good.

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

Thanks
Jambai

Sachin
Guest
Sachin

Hi, Thanks for the post. Your solution worked!

Nikita
Guest
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
Guest
Gamecock

Great fix! Thank you so much!

Mike
Guest
Mike

I love you.

Sherri
Guest
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
Guest
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
Guest
Janet Huang 1965

Thank you so much for the fix. Worked great!

Janet

Anonymous
Guest
Anonymous

Not at all working>Janet

HiPlease give the proper solution

Thanks

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

Anonymous
Guest
Anonymous

Not working

shrishail
Guest
shrishail

Hi
your solution woked.It is very nice

Anonymous
Guest
Anonymous

Hiyour solution woked.It is very nice

Brian
Guest
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.

Anonymous
Guest
Anonymous

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.  (Quote)

Anonymous
Guest
Anonymous