Thread: is there a limit to the # of rows in a pivot table?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default is there a limit to the # of rows in a pivot table?
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

Reply With QuoteReply With Quote