Memory problems

  • Thread starter Thread starter MFRASER
  • Start date Start date
M

MFRASER

Is there a limit to the size my excel spreadsheet can be. I am creating
several pivot tables from recordset that I import, and I am looking at Mem
Usage under Task Manger and currently I am at 124 meg. This does seem right
for a file that is only a few meg. Is there a way to free up the memory?
Should I be doing a save between building pivot tables?
 
Ok I found an article in the knowledgebase but I don't understand how to do
the following. Can I have multiple WorkBooks inside of Excel?

PivotTable Wizard Step 1: Where Is the Data That You Want to Analyze?
When Excel creates the cache for a PivotTable, both the original data and
the cached data may be kept in memory, depending on the data source option
that you select. If your data source is large or if you are creating several
PivotTables from separate data sources, these multiple copies of data may
use up your computer's available memory, which will adversely affect the
performance of Excel. To save memory, you can use a closed original data
source or a single data source when you create multiple PivotTables.

The memory usage implications for each of the data source options in step 1
of the PivotTable Wizard are described in more detail in the following
sections.

back to the top
Microsoft Excel List or Database, or Multiple Consolidation Ranges
When you select Microsoft Excel list or database or Multiple consolidation
ranges as your data source, if this data is in an open sheet, two copies of
the data are kept in memory when Excel creates the PivotTable. To conserve
memory, close the workbook that contains your original data, and create the
PivotTable in a separate workbook. This way, only the cached data is kept in
memory.

back to the top
 
Here is the error I get
"The instruction at "0x77f57eb2" referenced memory at "0xfffffffd". The
memory could not be "read"
 
Back
Top