Pivot Table Formating borders and columns widths

pullinsb

New Member
Joined
Oct 13, 2006
Messages
1
How do I maintain border and columns width formats when refreshing and changing the page field? Preserve Formatting is checked and Autoformat is unchecked. Cell shading remains but no other formating when table is refreshed.
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,113,990
Messages
5,545,365
Members
410,679
Latest member
rolandbianco
Top