Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Tables lose some formatting when Updated
A customer asked me this question about Pivot Tables and I
want to make sure I give him the right info. 1)When my customer updates pivot tables the formatting always changes even though he has selected the check box stating to keep formatting. 2) I tried this out and it seems to keep most of the formatting like color, bolding and dollar signs but it did not keep the bordering. 3) Is there a way to have it keep all formatting for a report and have it maintain the integrity of the formatting even though he updates the data? Any help would be greatly appreciated ! Jugglertwo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot tables - inserting columns | Excel Worksheet Functions | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |