Microsoft Office Tutorials and References
In Depth Information
THE FINISHED PRODUCT
Merge labels: Check this box if you want Excel to merge the cells for outer
row and column labels. Doing so may make the table more readable.
Preserve formatting: Check this box if you want Excel, when it updates the
pivot table, to keep any of the formatting that you applied.
Repeat item labels on each printed page: Check this box to set row titles
that appear on each page when you print a PivotTable report.
Mark Totals with *: Available only if you generated the pivot table from an
OLAP data source. If checked, displays an asterisk after every subtotal and
grand total to indicate that these values include any hidden items as well as
Page layout: You can specify the order in which you want the page fields
Fields per column: You can specify the number of page fields to show before
starting another row of page fields.
For error values, show: You can specify a value to show for pivot table cells
that display an error.
For empty cells, show: You can specify a value to show for empty pivot
Set print titles: Check this box to set column titles that appear at the top of
each page when you print a PivotTable report.
Save data with table layout: If you check this option, Excel stores an
additional copy of the data (called a pivot table cache ), enabling Excel to
recalculate the table more quickly when you change the layout. If memory is an issue,
you should keep this option unchecked (which slows updating a bit).
Enable drill to details: If checked, you can double-click a cell in the pivot
table to view the records that contributed to the summary value.
Refresh on open: If checked, the pivot table refreshes whenever you open
Refresh every x minutes: If you are connected to an external database, you
can specify how often you want the pivot table refreshed while the workbook
Save password: If you use an external database that requires a password, you
can store the password as part of the query so that you don’t have to reenter it.
Background query: If checked, Excel runs the external database query in the
background while you continue your work.
Optimize memory: This option reduces the amount of memory used when
you refresh an external database query.