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?