Excel 2004 for Mac Solution Center

PivotTable

Microsoft Excel 2004 for Mac Read Me file
Article contains the contents of the Microsoft Excel 2004 for Mac Read Me file.
Description of the Microsoft Office 2004 for Mac 11.3.3 Update
Describes the Microsoft Office 2004 for Mac 11.3.3 Update.

Formatting is not retained in PivotTable in Excel
When you pivot fields or update data in a PivotTable, the formatting is cleared. This problem occurs if you update data or change the layout of the table when the following conditions are true: You click PivotTable on the PivotTable toolbar, point...
You receive an error message when you try to open an Excel XML Spreadsheet document that contains a pivot table in Excel 2004 for Mac
Discusses the problem where you cannot open a XML Spreadsheet file in Excel 2004 for Mac.

Microsoft Support