software

My formats reset when I update my pivot tables.. I unchecked the quot;Auto
Formatquot; option in quot;table optionsquot;, but this hasnt helped. Specifically
I lose the quot;Wrap Textquot; 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?--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: www.excelforum.com/member.php...foamp;userid=7092
View this thread: www.excelforum.com/showthread...hreadid=533761
Did you check the quot;preserve formatingquot; 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 quot;refresh dataquot; button. You can drag this button to your
toolbar.

Regards,
Arien--
Arien
------------------------------------------------------------------------
Arien's Profile: www.excelforum.com/member.php...foamp;userid=1892
View this thread: www.excelforum.com/showthread...hreadid=533761
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
quot;table optionsquot; 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?--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: www.excelforum.com/member.php...foamp;userid=7092
View this thread: www.excelforum.com/showthread...hreadid=533761
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 quot;allquot; 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--
Arien
------------------------------------------------------------------------
Arien's Profile: www.excelforum.com/member.php...foamp;userid=1892
View this thread: www.excelforum.com/showthread...hreadid=533761
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 quot;Noquot; 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....--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: www.excelforum.com/member.php...foamp;userid=7092
View this thread: www.excelforum.com/showthread...hreadid=533761