Defer an Automatically Update of PivotTable Layout Report in Excel 2007

Follow by Email

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:

Leave a Reply

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

To avoid automated spam,Please enter the value *

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>