Joining Pivot Tables

Jackeb · Apr 9th, 2002, 02:13 AM

Ok,

I give up....

How do you join a pivot table??

I have two sets of data with identical heading in different sheets of a different work book and I want to put all of this into one pivot table in a second workbook...

is this possible??

Cheers

Ed

sen_edp · Apr 9th, 2002, 02:41 AM

Hello Ed

Yes you can do it.
All you have to do is to consolidate the ranges you want from the pivot table wizzard.
I tried it and it works.

Andreas

Jackeb · Apr 9th, 2002, 03:02 AM

cheers muchly

Apr 9th, 2002, 03:02 AM	#3
Jackeb Board Regular Join Date: Mar 2002 Posts: 81	cheers muchly __________________ Ed Jackson "Do not worry about your problems with mathematics, I assure you mine are far greater." A. Einstien

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 02:13 AM	#1
Jackeb Board Regular Join Date: Mar 2002 Posts: 81	Ok, I give up.... How do you join a pivot table?? I have two sets of data with identical heading in different sheets of a different work book and I want to put all of this into one pivot table in a second workbook... is this possible?? Cheers Ed

Apr 9th, 2002, 02:41 AM	#2
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	Hello Ed Yes you can do it. All you have to do is to consolidate the ranges you want from the pivot table wizzard. I tried it and it works. Andreas