Change the defaults for your Pivot Tables by: Selecting FILE OPTIONS DATA Edit Default Layout Like this:Like Loading... Related Categories: Excel Tips