XL98: Formatting Not Retained in PivotTable (185304)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q185304 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:
and then click Show Topics. Select the "Format a PivotTable" topic, and
click Go To. If you are unable to find the information you need, ask the
Office Assistant.
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kbprb kbualink97 KB185304 |
|---|
|