2007 Excel with SQL 2000 report

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

2007 Excel with SQL 2000 report

Author

Topic

dzbom
Starting Member

4 Posts

Posted - 2007-09-09 : 23:43:44

Hi all

I am wondering if there is a solution for our current issue i.e. we can't export the query report from SQL report services into 2007 Excel.
We have no problem with Excel 2003.

Any help/reply would be much appreciated.

Cheers

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-09-09 : 23:59:55

quote:
Originally posted by dzbom

Hi all

I am wondering if there is a solution for our current issue i.e. we can't export the query report from SQL report services into 2007 Excel.
We have no problem with Excel 2003.

Any help/reply would be much appreciated.

Cheers

What happens when you try?

Future guru in the making.

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-09-10 : 00:00:44

Have you tried applying the compatibility pack to Excel?
http://office.microsoft.com/en-us/products/HA101686761033.aspx

Future guru in the making.

dzbom
Starting Member

4 Posts

Posted - 2007-09-10 : 00:45:22

When I try to export a report from SQL report services into Excel, the first box asked me do you want to open or save this file?
Type : Microsoft Office Excel 97-2003 Worksheet

then click open it gave me error message:
The file you are trying to open, Filename.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. Do you want to open the file now?

No matter "open" or "save" I still can't open it with Excel 2007, but Excel 2003.

Do you think I need the compatibility pack?

Thanks for your help.

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-09-10 : 09:01:57

quote:
Originally posted by dzbom

When I try to export a report from SQL report services into Excel, the first box asked me do you want to open or save this file?
Type : Microsoft Office Excel 97-2003 Worksheet

then click open it gave me error message:
The file you are trying to open, Filename.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. Do you want to open the file now?

No matter "open" or "save" I still can't open it with Excel 2007, but Excel 2003.

Do you think I need the compatibility pack?

Thanks for your help.

Yes, I would try applying it first and see if that fixes it.

Future guru in the making.

dzbom
Starting Member

4 Posts

Posted - 2007-09-10 : 18:42:40

Hi
Thanks for your reply.
I gave it a try, it does the same thing :(, and also I saved this report as Microsoft office 97-2003 worksheet, I am able to open it with office 2003, but office 2007.

Please help.

Thanks again

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-09-10 : 20:02:57

quote:
Originally posted by dzbom

Hi
Thanks for your reply.
I gave it a try, it does the same thing :(, and also I saved this report as Microsoft office 97-2003 worksheet, I am able to open it with office 2003, but office 2007.

Please help.

Thanks again

I think I found you a solution after a bit of research on your error, this seemed to work for someone, apparently a change in the security model:

Change the registry:

HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\12.0\EXCEL\SECURITY
Rightclick --> new>DWORD>
add key ExtensionHardening
value = 0

make sure the key word without any spaces

Future guru in the making.

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-09-10 : 20:24:44

A bit more on the source:
http://forums.asp.net/p/1101709/1864224.aspx

Future guru in the making.

dzbom
Starting Member

4 Posts

Posted - 2007-09-10 : 21:28:29

Hi

Very much appreciated. It WORKED well. Yeeeehaaa!!!!
I found that website too but I am a bit scared of REGISTRY key :).
Once again thanks a lot for your great great help and support all the way long.

Cheers

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-09-10 : 21:32:54

quote:
Originally posted by dzbom

Hi

Very much appreciated. It WORKED well. Yeeeehaaa!!!!
I found that website too but I am a bit scared of REGISTRY key :).
Once again thanks a lot for your great great help and support all the way long.

Cheers

No problem at all, this happens from time to time with security fixes that end up ultimately reducing functionality in some way. It's always hard to find the answer when that happens, glad I could assist.

Future guru in the making.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources