Pivot table

  • Thread starter Thread starter chrish
  • Start date Start date
C

chrish

I have a user with a 45MB excel file and he is trying to create a pivo
table with it. When he does it gets an out of memory msg. But he ha
500MB of ram and a 2gig swap file.

What would cause this? IS there a limit on the size a pivot table o
worksheet can be?

Thank
 
Hi Chris
You might be running into an excel limitation. This is from the help file "Worksheet and workbook specifications

Maximum number of items in a PivotTable 8,00
Maximum number of pages in a PivotTable 8,00

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- chrish > wrote: ----

I have a user with a 45MB excel file and he is trying to create a pivo
table with it. When he does it gets an out of memory msg. But he ha
500MB of ram and a 2gig swap file

What would cause this? IS there a limit on the size a pivot table o
worksheet can be

Thank
 
Back
Top