ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Pivottable columns multiply in excel 2007 (https://www.excelbanter.com/excel-worksheet-functions/150667-pivottable-columns-multiply-excel-2007-a.html)

Haffi

Pivottable columns multiply in excel 2007
 
I have a pivottable that worked just fine in Excel 2003, but Excel 2007
doesn't handle correctly.
I grouped a few items in the column area, but when a hide details/collapse
the group, Excel 2007 still leaves it in multiple columns, with up to 1
column for each row in the table.

Be blessed

Mike Skibyak

Pivottable columns multiply in excel 2007
 
Haffi:
I thought I was the only person having this problem. In my case it also
seems to effect the PivotTable's results.

I'm going to try reloading Excel to see if that fixes the problem.

Mike


"Haffi" wrote:

I have a pivottable that worked just fine in Excel 2003, but Excel 2007
doesn't handle correctly.
I grouped a few items in the column area, but when a hide details/collapse
the group, Excel 2007 still leaves it in multiple columns, with up to 1
column for each row in the table.

Be blessed



All times are GMT +1. The time now is 12:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com