Date: 09/15/05 (SQL Server)    Keywords: no keywords

Does anyone know of a size limit for exporting to Excel in Reporting Services?

I have been deploying reports extensively in RS and the only problem I've run into concerns large reports. Large is around 20000 rows with 30 columns. Either my machine looks up (Excel using 99% CPU) or I get a "Server Unavailable" error.

Anyone else have this happen? Any ideas?
Thanks!

Source: http://www.livejournal.com/community/sqlserver/34096.html