Access 2003 Pivot Table - 100% CPU Usage

[lphelps]

I am trying to create a pivot table in Access 2003 to display data from a SQL
2000 table. I am able to make this work with very, very small amounts of
data. However, when using a larger table, the CPU usage immediately goes to
100% and the Windows task manager indicates that Access is not responding.
For all practical purposes, Access hangs at that point.

Has anyone else encountered this problem and found a solution?
Thanks.

 

[Alvin Bruney [MVP]]

How much data are we talking about? Are you up to date on your service packs
and patches for the Office Web Components and windows?

--
Regards,
Alvin Bruney

Coming this month
The Microsoft Office Web Components Black Book with .NET
http://tinyurl.com/27cok

 

[PPGDDT]

I had this problem as well. The problem came down to the fact that I had too
many rows in my pivottable. Each Row represented a group-by with the abiltiy
to sub-total. All of the processing killed the CPU. Move some of your Row
fields into the data section to simplify the query.