I am exporting a 12,000 row, 20 column report to Excel from SSRS 2008. Once opened in Excel, everything is fine. If I further filter the data through Excel (no external data connections) performance degrades. If I filter down to say 20
rows, it nearly completely bogs down my entire PC. I've emailed this spreadsheet to several others, who then experience the same issue.
If I export this same set of data from a different BI tool, such as Microstrategy, there are no performance issues what so ever.
View Complete Post