Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Sort Error
Hope someone has can help here.
My database has a Pivot Report option that enables me to create a pivot table within the program using a query. Once that is done, there is the option to export the pivot report to Excel. What happens is that the Pivot table looks great in the database report, but when it is exported to Excel, the sorting changes. It is a simple table, based upon 2 sort items and one total field. Within the database, it sorts perfectly, and I create grouped items, But when it is exported to excel, the groups stay in tact, but the order of the groups changes randomly. Anyone know of this behavior in Excel? THANKS! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleted the pivot table - continue to get the "overlap" error message | Excel Discussion (Misc queries) | |||
Sort pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Wizard Error (Expected 52) | Excel Discussion (Misc queries) | |||
Error message when using Pivot Table | Excel Discussion (Misc queries) | |||
pivot table error (25000 rows!!) | Excel Discussion (Misc queries) |