XL98: Formatting Not Retained in PivotTable

• Microsoft Excel 98 Macintosh Edition

SYMPTOMS

When you pivot fields or update data in a PivotTable, the formatting is cleared.

CAUSE

This problem occurs if you update data or change the layout of the table when one of the following conditions is true:

• You click PivotTable on the PivotTable toolbar, point to Select, and then click Enable Selection to clear the selection.


-or-


• You click to clear Preserve Formatting in the PivotTable Options dialog box.

MORE INFORMATION

Microsoft Excel 98 Macintosh Edition includes "persistent" formatting. This means that formatting in PivotTables remains intact through pivots and updates. The formatting is linked to items and fields in the PivotTable that cause formatting to be removed when data is updated or fields are pivoted. To bind formatting to a selection of cells, select items using "structured" selection.

Structured selection allows you to select PivotTable areas, labels or data, based on the data structure (for example, an item or field). This allows you to select different parts of the data that is associated with each item or field before you perform another action, such as formatting or data analysis. Structured selections are of three types: data, labels, or labels and data.

To make structured selection available, click PivotTable on the PivotTable toolbar, point to Select, and then click Enable Selection.

NOTE: Microsoft Excel does not retain changes to cell borders when you change the layout or refresh a PivotTable.

REFERENCES

For more information about formatting PivotTables, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of Mac OS earlier than 8.0), click the Index button in Microsoft Excel 98 Macintosh Edition Help, type the following text:

PivotTables, formatting

Additional query words: XL98 pivot table

Keywords : kbualink97 kbdta xlformat xlpivot
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb