Pivot Tables not using all memory
 

Hi Neelu,

Excel has its own internal memory memory manager which has limits.
(see http://www.decisionModels.com/memlimitsc.htm)

You can use the minimise memory option on the pivot table to save some
memory, but that will make creating the pivot table extremely slow.

or you can create a Cube file and build the Pivot table from that (also
slows things down).

or you could try excluding a column if possible.

Charles
______________________
Decision Models
The Excel Calculation Site
www.DecisionModels.com

"Neelu" wrote in message
...
Hi,

I have an Access db that stores all the data
( 1 table , 400,000 rows, 12 columns)

There is a Excel pivot table based on this Access table.

While refreshing, it reads till 390,000 rows and then
shows error :
Excel cannot complete this task with the available
resources. Choose less data or close other applications

I am using Office XP, Windows 2000
RAM = 785 MB. virtual memory : 2000 MB

If I look at the task manager, it is using only part of
the memory 400 MB

Any suggestions why Excel is not using the memory
efficiently ?

Thanks