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


The information in this article applies to:

  • Microsoft Excel 2000
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.

REFERENCES

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.
Modification Type:MajorLast Reviewed:9/25/2003
Keywords:kbprb KB210826
©2003 Microsoft Corporation. All rights reserved.