I need to pivot different tabs in one pivot table, is it a way to quickly
link all tabs in a data range?

Hi

You can create a number of different Pivot Tables all from the same
source data.
Having created the first PT, go through the procedure again.
Give the source data as the same range or same name as you did for the
first. The wizard should ask you if you want to use the same Pivot Cache
to cut down on size, reply yes and point to the first cache.

Repeat the procedure for as many other PT's as you wish, which can be
placed on the same tab or different tabs according to your needs.

--
Regards

Roger Govier


"Holly" wrote in message
...
I need to pivot different tabs in one pivot table, is it a way to
quickly
link all tabs in a data range?

You can create a pivot table from data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want.
There's more information he

http://www.contextures.com/xlPivot08.html


Holly wrote:
I need to pivot different tabs in one pivot table, is it a way to quickly
link all tabs in a data range?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Ooops!!
Sorry Holly, totally misread your request.

--
Regards

Roger Govier


"Roger Govier" wrote in message
...
Hi

You can create a number of different Pivot Tables all from the same
source data.
Having created the first PT, go through the procedure again.
Give the source data as the same range or same name as you did for the
first. The wizard should ask you if you want to use the same Pivot
Cache to cut down on size, reply yes and point to the first cache.

Repeat the procedure for as many other PT's as you wish, which can be
placed on the same tab or different tabs according to your needs.

--
Regards

Roger Govier


"Holly" wrote in message
...
I need to pivot different tabs in one pivot table, is it a way to
quickly
link all tabs in a data range?