M
MFRASER
Is there a limit to the number of sheets I can add to a workbook?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Robert Rosenberg
Only your computer's memory. I've had over a 1000 in one workbook but each
one had a small amount of data.
_______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com
one had a small amount of data.
_______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com
G
Gord Dibben
MFRASER
In addition to Robert's info, open Help and type "limits"(no quotes) into the
Answer Wizard.
A host of limits and specifications will tumble out.
Gord Dibben Excel MVP
In addition to Robert's info, open Help and type "limits"(no quotes) into the
Answer Wizard.
A host of limits and specifications will tumble out.
Gord Dibben Excel MVP
M
MFRASER
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
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
M
MFRASER
Here is the error I get
"The instruction at "0x77f57eb2" referenced memory at "0xfffffffd". The
memory could not be "read"
"The instruction at "0x77f57eb2" referenced memory at "0xfffffffd". The
memory could not be "read"