Another question from Columbus, Indiana. How can you choose a default style (from the PivotTable Design tab) for all future pivot tables? Yes, there is a Set as Default choice, but it only applies to future pivot tables in this workbook. My method involves adding a default to BOOK.XLTM.
Also in this video, a pivot table formatting oddity from Excel MVP Wyn Hopkins.
Table of Contents
(0:00) Introduction
(0:44) The colors on Page Layout impact the Pivot Table Styles
(1:25) Changing a pivot table style default only affects this workbook
(3:40) A FAST way to get to Browse during Save As
(4:54) MVP Wyn Hopkins Discovers a bizarre pivot table formatting trick!
(5:33) Change the colors and style of your borders using Format Cells
(7:23) Pivot Table Data Crunching book & wrap-up