worksheet row limit/pivot table

[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

 

[Peter Atherton]

-----Original Message-----
hi,

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
.

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

[email protected]

 

[Myrna Larson]

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.