Pivot - multiple source

[CGV]

Hi All,

I am working on a file which use different tabs with the same heading and I would like create a single Pivot to gather the information on the tabs and using the heading in the tabs.
Can anyone be able to help?

thanks

Carmine

[Sadath31]

hi,

press ALT then D then P
then follow the instruction in the wizard..

[CGV]

Thank, when I do try to connect the file give me an error.
I am using one excel file, gathering infos from 3 tabs within the file and using the 4th tab for the pivot.....

[MarvinP]

Hi CGV,

There is an old Pivot Consolidate Wizard that may be what you need. You can add the icon and the tool by following these instructions:
http://www.addintools.com/documents/...vot-table.html

You need follow the third picture on the link above and add the Pivot Wizard and use it.

[CGV]

Hi Marvin, thanks for this, but the pivot give me only 4 items and not the full column heading as per standard pivot..... how can I use it as per standard Pivot?