I have slicers and pivot tables on a single sheet and would like to preserve the pivot table size after refreshing the data. Any ideas as to how I can achieve this?

2

1 Answer

This is a setting that can be changed in Pivot Table Options > Layout and Format. Uncheck "Autofit Column Widths on Update".

Believe this should help you. Good Luck.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy