Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Joel 48371
 
Posts: n/a
Default Retain PivotTable formatting after "Refresh Data"

PivotTable formatting changes each time the "Refresh Data" button is clicked.
It is very frustrating to have SOME formatting changes each time the data is
refreshed. The last Row Field column always changes width, the "Total"
heading in Data Items always resets to top, left align, unbold, box borders,
and no fill. Is there a formatting method that RETAINS the formatting?
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

Set the pivot table to preserve formatting:
On the pivot toolbar, choose PivotTableTable Options
Add a check mark to 'Preserve formatting', click OK
Remove the check mark from AutoFormat Table
Click OK

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 the above suggestions don't work, you could record a macro as you
refresh and reformat the pivot table. Then, run that when you want
to update.


Joel 48371 wrote:
PivotTable formatting changes each time the "Refresh Data" button is clicked.
It is very frustrating to have SOME formatting changes each time the data is
refreshed. The last Row Field column always changes width, the "Total"
heading in Data Items always resets to top, left align, unbold, box borders,
and no fill. Is there a formatting method that RETAINS the formatting?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting data rn Excel Discussion (Misc queries) 1 March 17th 05 11:01 AM
Glue/Lock cells to external data before refresh Jo Betty Smith Excel Discussion (Misc queries) 0 February 17th 05 12:55 AM
Effect of Conditional Formatting, Data Validation Bill Sturdevant Excel Discussion (Misc queries) 1 January 26th 05 12:50 AM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 06:55 PM
How to lock a worksheet and enable the PivotTable refresh data opt Saariko Excel Worksheet Functions 3 October 31st 04 04:02 PM


All times are GMT +1. The time now is 06:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"