worksheet row limit/pivot table

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

hi,

i recently came to the end of a worksheets row capacity.

I have a pivot table that runs of the back of this worksheet.

Is there a way to extend the worksheet beyond the 65k odd row limit or
can icreate a pivot table that is fed from more than one worksheet?

Thanks
Neil
 
-----Original Message-----
hi,
Click to expand...
Is there a way to extend the worksheet beyond the 65k odd
Click to expand...
row limit or can icreate a pivot table that is fed from
more than one worksheet?
Thanks
Neil
.
Click to expand...
Neil

No 65K is the limit. You can copy the data into Access
(database) and use this as the basis of the Pivot Table or
use Quatro Pro (limit 1 million rows) and use Cross Tab
Queries similar to PivotTables.

Perhaps someone else has amalgamated two or more sheets.

Regards
Peter

(e-mail address removed)
 
Yes, it can be "fed" from more than one worksheets. Create your a Pivot table
specifying "Multiple Consolidation Ranges" as the data source. There's more
information in Help.
 
Back
Top