Joel 48371

Posts: n/a

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 10:01 AM
Glue/Lock cells to external data before refresh	Jo Betty Smith	Excel Discussion (Misc queries)	0	February 16th 05 11:55 PM
Effect of Conditional Formatting, Data Validation	Bill Sturdevant	Excel Discussion (Misc queries)	1	January 25th 05 11:50 PM
Pulling data from 1 sheet to another	Dave1155	Excel Worksheet Functions	1	January 12th 05 05:55 PM
How to lock a worksheet and enable the PivotTable refresh data opt	Saariko	Excel Worksheet Functions	3	October 31st 04 03:02 PM

All times are GMT +1. The time now is 08:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us