Pivot Table - Formats Reset... why?

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?

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

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?

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

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....

What eventually worked for me was unfiltering the pivot table and using the Analyse>Select>Entire pivot table option to select the whole table.

Alignment formatting changes then stuck on save/refresh. I couldn't find a way to do this for individual columns.

I use Excel 365 Home version. I struggled with the same issue; on each refresh of Pivot Table, my Row Field alignment changes to Left align.

My solution: Under "Pivot Table Analyze", "Options", make sure "preserve cell formatting on update" is checked.

Then go to your Pivot Table; highlight all Row Fields in the particular column (exclude Row Headers, highlighted area should not go outside the Pivot Table), set your alignment and save the file.

This worked for me. Row field alignment did not change on refresh.

Where I went wrong: I highlighted areas outside the Pivot Table and set my alignment.

Hope this will work for you.