Loading ...

  • home »
  • blogs »
  • Vivek Thakur »
  • The file you are trying to open, ‘XXX.xls’ is in a different format than specified by the file extension.

blogs

The file you are trying to open, ‘XXX.xls’ is in a different format than specified by the file extension.

(10)
(74136)
0
/5
Avg: 0/5: (0 votes)

posted 1/15/2009  by Vivek Thakur

While exporting HTML in excel format you may encounter this error when opening the exported Excel file:

The file you are trying to open, ‘XXX.xls’ is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file.

This bug cannot be fixed through asp.net code. Here is more information on this problem:

http://blogs.msdn.com/vsofficedeveloper/pages/Excel-2007-Extension-Warning.aspx


If this app is running on an intranet and some specific computers is heavily using this export to excel feature, then we can suppress this warning notification by modifying the registry on each of the client computers as follows:

 

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

   1. Open your Registry (Start -> Run -> regedit.exe)
   2. Navigate to HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\12.0\EXCEL\SECURITY
   3. Right click in the right window and choose New -> DWORD
   4. Type “ExtensionHardening” as the name (without the quotes)
   5. Verify that the data has the value “0″

 

 

 

 

Comments (10)

Susmitha Katakam
Anonymous User said:
Works perfectly nice!!!
6/26/2009
 · 
Comment
 
by
Gary
Anonymous User said:
That was extremely simple! Thanks for the advice!!
8/7/2009
 · 
Comment
 
by
Anthony
Anonymous User said:
It worked fine for me except... when my Excel file opens up, it is a blank page... and I have to click elsewhere and come back to Excel to see my file then. So in the end, I need more clicks!
9/16/2009
 · 
Comment
 
by
Delete
Walter
Walter said:
I have numbers of excel file which was save in my external hardisc. This error show up every time i try to open the file. After it open, it show me some script type of wording. Anyone can help me as i can't even see the contain of my excel.
12/4/2009
 · 
Comment
 
by
Delete
hip hop anonymous
hip hop anonymous said:
worked perfect!!! thanks!
12/23/2009
 · 
Comment
 
by
Delete
Peter
Peter said:
Is there any other alternative also?? the application is used by large number of users so its not possible to change the registry setting of each user. Ur help will be highly appreciated
1/11/2010
 · 
Comment
 
by
Delete
Peter
Peter said:
Is there any other alternative also?? the application is used by large number of users so its not possible to change the registry setting of each user. Ur help will be highly appreciated
1/12/2010
 · 
Comment
 
by
Delete
Ei Ei
Ei Ei said:
I'm facing this problem too. Is there any other solution that we can do other than changing registry on client pc and changing Group Policy Setting on domain?
2/1/2010
 · 
Comment
 
by
Delete
Excel_test
Excel_test said:
Is there any other work around since the application is used by number of users and it is not possible to change the registry settings for each user. Is there some code change in asp that will help??
2/3/2010
 · 
Comment
 
by
kuldeep1553
kuldeep sharma said:

 

when i registring process date showing like this my data is removed i have lots sheets in my file please help me to recover my data

 

VERSION 1.0 CLASS
BEGIN

  MultiUse = -1  'True
END

Attribute VB_Name = "Sheet1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True

Attribute VB_Exposed = True

 
7/26/2010
 · 
Comment
 
by
Add a new comment

Top posts

    Vivek Thakur's latest blog posts

    Quick Vote

    What kind of email newsletter would you prefer to receive from CodeAsp.Net?