create pivot table from different workbook

Hi Expert's excel 2007

I want to create a pivot table in workbook a from the data in workbook b...I am in workbook a sheet abc....

and cannot figure out how to establish the connection or where to start. ..

need a step by step guide. .
route217Asked:
Who is Participating?
 
helpfinderConnect With a Mentor IT ConsultantCommented:
Hi,
in your A workbook go to Insert>Pivot table and choose Use an external data source/Choose connection:
01
then click Browse for more
02
and select your B workbook as a data source. Then you should be able to create Pivot in workbook A based on data in workbook B (for easier handle woth this it would be great to have separate sheet in workbook B only with desired data)
0
 
route217Author Commented:
Thanks help finder..
0
 
route217Author Commented:
Hi help finder

when I follow you're steps...I am not getting the column heading nor data coming through second workbook. ...
0
 
helpfinderIT ConsultantCommented:
Hi route,
could you tell me exact steps you are doing? or insert some samples from you?

You can see at my printscreen when I am using the exact same steps as I provided here I am able to get correct Pivot table with columns as they are in the source workbook
03.PNG
0
 
route217Author Commented:
Sorted. ..
0
All Courses

From novice to tech pro — start learning today.