After upgrading to Excel 2007, you may get the following error 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?
This errors particularly occurs when you’re trying to open an XLS file (Excel 2000-2003) with Excel 2007.
The easiest way to solve this problem, is to insert the following registry key. This will suppress the notification:
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security]
“ExtensionHardening”=dword:00000000
The step-by-step instructions are as follows:
- Click Start, click Run, type regedit.exe and press ENTER. This will open your Registry
- Navigate to HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\12.0\EXCEL\SECURITY
- Right click in the right window and choose New -> DWORD
- In the Name field, type “ExtensionHardening“ (without the quotes)
- Verify that the data has the value “0″
I advice the steps above to solve the problem, despite the fact that it is quick and dirty.
If you want a more constructive way, you should define MIME types and associate them with extensions.
When you use a Document Management System (like Sharepoint or Livelink), you can try adding these:
.xls = application/msexcel
.xlsx = application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
This is good information thanks for share
Hi,
Your solution really worked. Its an excellent trick.
Thanks,
Hemanth
Excellent trick to avoid warning..Thanks alot
excellent trick
Not Working………… Can Anyone Help needed Urgent………….
what a solution dear
nice
selut
Excellent solution..
i already get rid the msg box but still it is on special characters. pls help
Super Solutions.
its Working Perfectly..
Excellent Solution
Excellent Reply
Excellent, it is worked for me.
Hi,
Good solution.Its worked Properly.Thank you.
Hi I tried adding HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\12.0\EXCEL\SECURITY
but my excel documents are still corupt. any help please
Thank you,It was worked for me
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
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 no option like security
what should i do?
plz help me
IT WORKED FOR BY CHOOSE THIS ONE . than”s
Solution Works Perfectly.
Thanks Christian!
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?
I get to the registry part fine, but I do not have the SECURITY part. Is there another spot I could put it? Thanks!
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.
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()
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
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 and is from trusted source before opening the file. Do you want to open the file now?” and when i tried word file its open square box and Photo shows no preview available. please help me
Thanks, This solved the problem.
Worked for me… :)
Given registry modification solution worked for me. Thanks
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
Excellent
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
That was excellent, “ExtensionHardening“
it worked like a Spell
thanks
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
Hi,
Is there any other alternative rather than changing the registry?
sorry, file open but not in correct formatt
Lovely…… I got rid of the annoying message-box :-)
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.
It works good.
Would lke to know is there any other alternative rather than changing the registry or group policy.
Thanks
Jambai
Hi, Thanks for the post. Your solution worked!
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?
Great fix! Thank you so much!
I love you.
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.
Thank you so much for the fix. Worked great!
Janet
Hi
your solution woked.It is very nice
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.
It work excellent, thanks for the help
Dear sir,
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.
This problem that i am facing. So please give me suggest . this is very important to us. So please help me sir. this is my Humble request for u. please reply me. i want suggestion from u. help me plz. even i tried the procedure. which u gave in the website but its not working.
plz help me sir. i wish u will help me
Regards,
Srinivas
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.
It worked! thx in Win7 too.
It worked fine ,Thanks
Thank you so much. I have inserted ExtensionHardening key in my registry. It is working fine with out any issue.
Hello i cannot open my excel file it was working fine suddenly it shows this error. I tried the way which you had mentioned above but doesn’t work out.
: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!„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€ ‘©{‘øÑ‘û1‘
Please advise how can i fix this file.
Any software or translator or any other way to change the extention to open and recover my data.
Please reply.
Thank.
This works great, thank you!
hello..my excel worksheet writes the following: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!„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€ ‘©{‘øÑ‘û1‘
so how can i repair the data that has been lost,,
and there is any way to translate this symbols to the original data that Ive inputted it????
please help.
Hi,
the solution really worked.
Thanks,
yogeesh.
Excellent! Thank you so much for this solution.
Hi,
Its working.
Thanks,
Devendra Patil,Jalgaon
Thanks a lot… this save my day :)
This really works !
Thank you,
Ananth
Hey Thanks For it Awesome its working
it really worked for me.Thanks for the solution
thanks for you friend but I use and try it
Hi,
wow great solution its working fine
thank you for your solution
Sridhar Gumpula
THANKS!!, IT REALLY WORKS.
BEST REGARDS.
sir
i have tried your trick, file become open with out any error but the content of file become changed in 0 1 and others alphabatic, please hel me out
I will try in all the possible cases and let you know.
hi
ive tries your trick , now i m not getting the error msg , but file is still corrupt all i c is special character but no data.
can u help me with that
thank u
We tried by setting in registry. Its working fine.
Eventhough is there any other way?.
Pls advice.
even i am same face if u found any solution let me
Thank you,
Narender
Do you have a solution for Vista? The registry values as explained must be in XP only, because the information is not found in the visa registry. Can you confirm. Thank you.
I had changed the registry values as suggested. I could able to open the files
without any error this is great and I am getting a blank worksheet and I am worried about my data. Any work around this to retreive my data back.
Thanks,
Surender.
Even changed the setting the ContentType for XLS as well as XLSX
I am getting the same problem with the error mesg “Different format than specified by the file extension”
Jon Where I have to add code “FilFormatNum” , cna you please give examples
This error is commonly caused when .SaveAs VBA code (or export from an application) specifies the file should be created as filename.xls whilst saving in 2007 (i.e. xml) format.
When this file is then opened:
- In Office 2007 you get the format file extension error but it will open and work fine
- In Office 97-2003 the file will open but will appear corrupted as 97-2003 cannot interpret xml files
The solution from a macro perspective is to modify the code to specify the file format by adding the following code if you need to share with people on older excel (this will make it save in .xls format as well as be named . xls):
FileFormatNum = 56
or
FileFormatNum = xlExcel8
If only sharing with 2007 users, modifying the filename to be filename.xlsx will also solve this issue (this can also be done manually if files are only used by 2007 users).
Hope this helps
nothing worked.. all tried .. changed .xls to .xlsx and changed in registry as well.
Any other solution..
No complicated reg settings or modifications, just rename the .xls extension to .xlsx, you are done.
I tried above solution and it works fine for me. But i don’t want to do any changes in registry .Is there any other solution ?
I am using c# and asp.net 2.0 . Here i am export grid view in excel file and when i opened excel file that time above warning message i am facing .
Regard,
Umesh.
Thanks God….Its working..Thanks to UUUUUUUU too
Inspite of setting the ContentType for XLS as well as XLSX…I am getting the same problem with the weird mesg “Different format than specified by the file extension”
Any help is highly appreciated
-Sreek
I don’t have security folder. I added the same under ..\EXCEL\ folder and it didn’t work
Hi I tried adding HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\12.0\EXCEL\SECURITY
but my excel documents are still corupt. any help please
Thank pal..It really hepled me
Thank you so very much. I’ve been pestered by that annoying pop-up for months; I deal with a very large number of Excel files that don’t have an extension and constantly throw this error. This has seriously given me 5 minutes of my day back.
I heard about not bad application-xlsx repair Microsoft, know how will display a dialog box with the question whether this worksheet should actually be scanned, also with help it you may try to open the necessary *.xls, *,xlt, *.xlsx, xlsm, *.xltm, *.xltx, *.xlam file and see an error message on the screen instead of it: Microsoft Excel unable to read file, This file is not in a recognizable format, etc.
hi
ive tries your trick , now i m not getting the error msg , but file is still corrupt all i c is special character but no data.
can u help me with that
thank u
Thanks for solution
Thank you! As a non techie…your instructions were great! It took care of the problem.
Its working!!!!! wonderful….
Thanks a lot.
Hi ,
I have already tried the above solution , it’s working. But i want the solution in the way that from the jsp code. If you find any solution
i will be very happy.
Thanks,
vasanth.
Hi,
Your solution really worked.Its excellent.
Thanks,
Amber Bhatnagar.