Duplicate Column Headings in Pivot Table from Access

[TallGuyinIT]

Hello,

I am trying to create a pivot table in Excel from an Access Database table. I am getting duplicate and triplicate column headings in the Pivot Table. The grand totals in the Pivot Table are correct, so it is not reporting the same data twice.

I first thought there might be a formatting problem with the Access data. I created the same pivot table within Access using the same table and got all unique column headings. I tried pushing the Access Pivot Table into Excel, and Excel generated the same multiple column headings as when I created the Pivot Table in Excel.

I use this same table in several pivot tables, although not this specific column heading. The column heading is a single layer from one column in my Access table. I cannot figure out why this is happening. Any assistance would be appreciated.

Thanks, Glen

 

[lameid]

I have only recenctly begun using pivot tables...

Have you tried exporting the data from Access to Excel or importing the data instead of linking it?

Another thought is that you may be able to workaround a linking issue by doing some or all of the grouping in Access in a query. Then link and Pivot the query in Excel.

Hopefully one of those works out as a workaround.

Maybe someone else will know what the real issue is.

The only thing that I can think may be immediately useful is the version(s) of the office applications you are using as well as the version of the file (a lot of people use 2000 MDB's with Access 2003).

 

[combo]

Pivot table has specific areas, they can hold row fields, column fields, page fields and data fields. It is not possible to duplicate field in total of first three areas (unless you duplicate field in the MS Query under different name). You can do it in data region, for different aggregation types for instance.
To remove any data field, untick it in the 'Data' drop-down or drag off from the data region with the pivot table wizard (layout).

combo