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
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 RS: Exporting to Excel - freezes Excel

Author  Topic 

Maxer
Yak Posting Veteran

51 Posts

Posted - 2007-08-08 : 08:31:42
When I export a report from Reporting Services that uses grouping with drill down, then save it to the desktop and open it in Excel, it causes Excel to freeze / stop responding.

I don't think it is due to having too many cells/rows/columns as if I take the same data as a flat file and dump it into Excel it works just fine.

I think it has to do with the grouping / Pivot Table in Excel.

Has anyone else run into this before?
   

- Advertisement -