if there is, how can this be increased

sheehanb, from help,

Maximum number of PivotTables on a sheet Limited by available memory
Maximum number of items in a PivotTable 8,000
Maximum number of pages in a PivotTable 8,000
Maximum number of row or column fields in a PivotTable Limited by available
memory
Maximum number of page fields in a PivotTable 256 (May be limited by
available memory)
Maximum number of data fields in a PivotTable 256
Maximum number of calculated item formulas in a PivotTable Limited by
available memory


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"sheehanb" wrote in message
...
if there is, how can this be increased

On Tue, 14 Nov 2006 13:31:02 -0800, sheehanb
wrote:

if there is, how can this be increased


I guess you did not check HELP? That would seem to me to be the first place to
go.


PivotTable report specifications

Row or column fields Limited by available memory

Based on that, it would seem logical to suppose that the limit can be increased
by adding memory.



--ron

Not really. Excel can not use all of your RAM. Available memory depends on
your version of XL. Check out this link...

http://www.decisionmodels.com/memlimitsc.htm
--
HTH...

Jim Thomlinson


"Ron Rosenfeld" wrote:

On Tue, 14 Nov 2006 13:31:02 -0800, sheehanb
wrote:

if there is, how can this be increased


I guess you did not check HELP? That would seem to me to be the first place to
go.


PivotTable report specifications

Row or column fields Limited by available memory

Based on that, it would seem logical to suppose that the limit can be increased
by adding memory.



--ron

On Tue, 14 Nov 2006 15:34:11 -0800, Jim Thomlinson
wrote:

Not really. Excel can not use all of your RAM. Available memory depends on
your version of XL. Check out this link...

http://www.decisionmodels.com/memlimitsc.htm


Good reference
--ron