If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Rapid input Via datasheet | RudyR_Seattle | General Discussion | 4 | January 31st, 2005 01:33 AM |
A macro to open files, refresh data, and close file in background? | Don Guillett | Worksheet Functions | 1 | May 5th, 2004 12:20 PM |
A macro to open files, refresh data, and close file in background? | denisecook | Worksheet Functions | 1 | May 4th, 2004 03:16 PM |
External Data refresh query | BeSmart | Worksheet Functions | 0 | April 30th, 2004 10:26 PM |
GetPivotData of data not visible in pivottable | Bas van Gestel | Worksheet Functions | 0 | March 30th, 2004 02:44 PM |