Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
Could anyone explain the Pivot Table options Format Report and Preserve Formatting and how they affect any formats you put on a pivot tables. I have a pivot table which is refreshed every day. It has Row, Column and Page selections but the formatting I apply changes after refreshes. Has anyone tamed the Pivot Table Beast and could point me in the right direction? Ta... Neily |
#2
![]() |
|||
|
|||
![]()
In some versions of Excel, you may have to enable selection (From the
Pivot toolbar, choose PivotTableSelect, and click on Enable Selection) Before formatting cells, use the selection feature to select the cells. For example, move the pointer to the top of a column in the pivot table (just above the column's heading cell). When the black arrow appears (like the one that appears when the pointer is over a column button), click to select the column in the pivot table. Then apply the formatting. If that doesn't work, you could record a macro as you refresh and reformat the pivot table. Then, run that when you want to update. Neily wrote: Hi, Could anyone explain the Pivot Table options Format Report and Preserve Formatting and how they affect any formats you put on a pivot tables. I have a pivot table which is refreshed every day. It has Row, Column and Page selections but the formatting I apply changes after refreshes. Has anyone tamed the Pivot Table Beast and could point me in the right direction? Ta... Neily -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
![]() |
|||
|
|||
![]()
Cheers Debra,
I found the black arrow thing and thought I had conquered it, but it started to misbehave. I'll try the other thing from the Pivot Tabe menu. Ta. "Debra Dalgleish" wrote: In some versions of Excel, you may have to enable selection (From the Pivot toolbar, choose PivotTableSelect, and click on Enable Selection) Before formatting cells, use the selection feature to select the cells. For example, move the pointer to the top of a column in the pivot table (just above the column's heading cell). When the black arrow appears (like the one that appears when the pointer is over a column button), click to select the column in the pivot table. Then apply the formatting. If that doesn't work, you could record a macro as you refresh and reformat the pivot table. Then, run that when you want to update. Neily wrote: Hi, Could anyone explain the Pivot Table options Format Report and Preserve Formatting and how they affect any formats you put on a pivot tables. I have a pivot table which is refreshed every day. It has Row, Column and Page selections but the formatting I apply changes after refreshes. Has anyone tamed the Pivot Table Beast and could point me in the right direction? Ta... Neily -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Formatting | Excel Discussion (Misc queries) | |||
Using Date Grouping in Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot Tables lose some formatting when Updated | Excel Discussion (Misc queries) | |||
Problem with times in pivot tables and graphs | Excel Discussion (Misc queries) | |||
Loosing My Pivot Tables during SAVE AS | Excel Discussion (Misc queries) |