sql server reporting services: Excel consuming 100% CPU -- sql server reporting services

You're in the

sql server reporting services

group:

Excel consuming 100% CPU

Fredrik
9/5/2005 2:07:02 AM

sql server reporting services:

Hi,
We are using RS Sp2 andExcel XP on the clients.
One report outputs 5000+ rows and are grouped like this:

account group (25 groups)
account (250 groups)
values (4725 rows)

When exported to Excel the XL-file is 11Mb+ !
All groups are collapsed in XL by default, and when trying to work in the
sheet XL consumes all CPU! If all groups are expanded it is possible to work
with the data and there is no unusual CPU consuming.
If collapsing a group again then the CPU consumtion becomes heavy again.

My question, is this a limitation in XL? If it is, does this work better in
XL 2003?
Is there anything we can do to boost performance, as it is now we cant work
in XL...

Any ideas???

/Fredrik

Re: Excel consuming 100% CPU

Bruce L-C [MVP]
9/5/2005 9:48:39 AM

At this point this is just an Excel file. It looks like Excel is not
handling that amount of data and that amount of groups very well. You could
ask in Excel newsgroup if XL 2003 might work better for you.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Re: Excel consuming 100% CPU

Fredrik
9/6/2005 3:26:02 AM

Tested 2003 but the same problem occured. I would be very happy to now what
the heck is going on in Excel here...

[quoted text, click to view]

Re: Excel consuming 100% CPU

Donovan Smith [MSFT]
9/6/2005 8:48:22 PM

The problem may be merged cells or show/hide regions. Excel reports with
thousands of these elements are slow to load because for each new cell they
need to check to see if it intersects with all of the other merged cells.
If you can, removing some of the show/hide elements or other obvious merged
cells and you should see a speed increase in Excel.

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn