Pivot Table - Formats Reset... why?

[shadestreet]

My formats reset when I update my pivot tables.. I unchecked the "Auto
Format" option in "table options", but this hasnt helped. Specifically
I lose the "Wrap Text" and Column Width settings. Any solutions?

Also, is there a way to update all pivot tables in a workbook at once,
without clicking on each page and then hitting the exclamation point?

 

[Arien]

Did you check the "preserve formating" in the pivottable options?

Regarding the second questions you can add an additional button to your
excel. Go to View|Toolbars|Customize the go to Tab Commands, choose Data
and look for the "refresh data" button. You can drag this button to your
toolbar.

Regards,
Arien

 

[shadestreet]

Thanks for the response. Yes, I have 'preserve formatting' checked,
they still reset. Strange because I have a second workbook with pivot
tables and those formats do not reset. I checked the settings in
"table options" to make sure they were identical.

As for the toolbar tip, if I press it at the toolbar will that update
every work-sheet within the active workbook if it has a pivot
table/chart?

 

[Arien]

Dear shadestreet,

Strange about the formating. The only thing I could think of would be a
certain selection that has been made in the page-filed of the layout of
the pivot tabel. Please make sure that "all" is selected at the left
top of the pivottable. Then make your formating before you make a
certain selection again.

Regarding the toolbar button; yes it should work for all sheets in the
workbook selected. But it would not hurt checking it by updating
manually to see if anything changes.

regards,
Arien

 

[shadestreet]

Thanks for the toolbar tip, but that does not work for me.

Perhaps the problem is that I have independant pivot-tables on each
page (they all use the same source data though). When I created them I
selected "No" when the prompt came up telling me it would be more more
efficient and require less memory to base them on existing pivot
tables.

I still have to go through each work-sheet and click the Exclamation
Point button to update.

Strangely enough, the refresh button on my toolbar doesnt work for
pivot-charts, only pivot tables....