Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2999
  • Last Modified:

How to export to excel 2007 from reporting services 2008

I am using reporting services 2008 and database on sql 2000. I have to export the report data into excel. The report contains 367 columns ( matrix report and columns are dynamic) But when I export it fails stating column limit is 256. Excel 2007 can accomodate 16000+ columns. How can I specify to export into excel 2007.
Thanks for the help....:)
1 Solution
Swami Varahagir,

How are you doing?

You need to export to .xlsx (the ???x part of the file name distinguishes between 97-2003 and the new 2007 format). Otherwise, .xls format (the defacto standard in Excel) is the very limited (256 column) version.

Hope this helps,

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Tackle projects and never again get stuck behind a technical roadblock.
Join Now