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

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.

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.

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.

For more information about differences between PivotTable Lists and PivotTable Reports, click Microsoft Excel Help on the Help menu, type About using Excel PivotTable reports that were imported from PivotTable lists on the Web in the Office Assistant or the Answer Wizard, and then click Search to view the topic.