route217
asked on
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. .
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. .
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi help finder
when I follow you're steps...I am not getting the column heading nor data coming through second workbook. ...
when I follow you're steps...I am not getting the column heading nor data coming through second workbook. ...
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
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
ASKER
Sorted. ..
ASKER