Friday, February 24, 2012

Export to Excel 2000

We're running SQL Server 2000 and our client is using Excel 2000. When
a report is exported to Excel they can't read them. Excel 2003 works fine.
We're both on SP4

How do I get it to export for Excel 2000?

Thanks,
Johnny

Have you installed (at least) Reporting Services SP1 on the box where you installed the SSRS windows/web service? The "out of the box" SSRS 2000 only exports into a format Excel 2003+ can read. If you put the service pack on, it will export into a format that Office 97/2000 can read, too|||

Russell --

Thank you. Good to know that it can be done. We're on SP4 here as well as the client.

Do I tell it to export to Excel 2000 rather than 2003? -- or is it supposed to be able to be read by 2000 automatically?

Right now they cannot open it using Excel 2000.

Thanks,

Johnny

No comments:

Post a Comment