Pivot table limitations

[Jackeb]

Does anyone know how to join two large pivot tables??

I have had to split my database query up into three sections to overcome the 8000 line limit in creating a pivot table.

any ideas?

Ed

[Mark W.]

There isn't a "line limit" for PivotTables. There is an 8,000 item limit. To better understand this distinction see the Excel Help Index topic for "Parts of a PivotTable". Items are highlighted in yellow.

[Jackeb]

ok... sorry... but even so... how would you get round the 8000 item limit??

[Mark W.]

On 2002-04-22 06:55, Jackeb wrote:
ok... sorry... but even so... how would you get round the 8000 item limit??

You can't -- it's a limit!

[Jackeb]

I was informed (not necessarily reliably) that there was a way of joining two pivot tables.... was i lied to then?

[Mark W.]

On 2002-04-22 07:25, Jackeb wrote:
I was informed (not necessarily reliably) that there was a way of joining two pivot tables.... was i lied to then?

You can base one PivotTable on the data used by another or you can source a PivotTable on a consolidation of numerious ranges, but the resultant PivotTable is still constrained by the limits outlined in the Excel Help Index topic for "Microsoft Excel 97 specifications".