Defer an Automatically Update of PivotTable Layout Report in Excel 2007

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/excel-pivot-tables/defer-an-automatically-update-of-pivottable-layout-report-in-excel-2007.html">
SHARE




To defer an automatically updated PivotTable layout report:

Check Defer Layout Update box at the bottom-left corner of PivotTable Field List dialog box.

Note: When the Defer Layout Update check box is selected the PivotTable layout is freezing, and many of PivotTable Tools Ribbon commands Options or Design are freezing as well.

Please follow and like us:
7


Leave a Reply

Your email address will not be published. Required fields are marked *


− three = 4

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>