Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot tables - memory issues - please help | Excel Discussion (Misc queries) | |||
XL 2007 - Out of Memory - memory leak/bug? | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Pivot Table Memory Issue - Excel crashes | Excel Discussion (Misc queries) | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |