Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preserve Formatting for Pivot table cross 'Refresh Data !'
Hello,
Is there a trick to preserve the formatting (ex column width) for pivot table cross 'Refresh Data!" option ? I've setting up several pivot tables and have carefully formatted them including setting the column width to make sure it all fits & prints properly on one page for example. However, whenever I do 'Refresh Data !' everything seem to get reset ? I've tried playing with several options such as the 'Perserve Formatting' in Pivot Table Option (check) or Refresh on Open (uncheck), etc. But nothing seems to work. What is the proper way ? THANKS ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting lost in a Pivot Table after a data refresh | Excel Worksheet Functions | |||
preserve formatting option in pivot table | Excel Discussion (Misc queries) | |||
Pivot Table - Preserve Formatting | Excel Discussion (Misc queries) | |||
Pivot Table - Preserve Formatting | Excel Worksheet Functions | |||
format changes on pivot table although preserve formatting is che. | Excel Discussion (Misc queries) |