Preserve Formatting for Pivot table cross 'Refresh Data !'

F

Felicia

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 !
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table data 0
Pivot Table - Preserve Formatting 0
preserve formatting option in pivot table 1
Preserve formatting of Pivot table template 0
Pivot Table refresh 3
Pivot Table loses formatting after refresh? 0
Pivot Table column sizing 0
Column width of Pivot Table data goes back to default when data refreshed 5

Top