Microsoft KB Archive/210826

= XL2000: PivotTable List Grouped by Week Becomes Grouped by Month in Exported Excel PivotTable =

Article ID: 210826

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q210826



SYMPTOMS
When you click Export to Excel from the PivotTable List Office Web Component, any fields that are grouped by weeks change to grouped by months when you view the PivotTable report in Microsoft Excel. There is no warning that this switch will occur.



CAUSE
Microsoft Excel does not support grouping by weeks for PivotTable reports. Therefore, when you click Export to Excel from the PivotTable List Office Web Component, all fields that are grouped by weeks are changed to months grouping.

NOTE: If you publish the PivotTable report as a Web page and add interactivity to the PivotTable report from Excel, the resulting PivotTable list in your Web browser reverts back to grouping by weeks.



MORE INFORMATION
Because PivotTable reports in Excel cannot display some PivotTable list layouts and calculations, the PivotTable report might look different from the PivotTable list on the Web.

