Fill Empty cells

Depending on the data in your “PivotTable”, you can fill text or the number zero when a cell is empty.
First select the “Options” tab, in the “PivotTable Tools”.
Click the “Options” button on the left side of the “Ribbon”.
Select “Options”.
This opens the “PivotTable Options”dialog.
Select the “Layout and format” tab.
Click the checkbox for “For empty cells show”.
In the box next to it, enter text or a number value that is to be displayed when the cell is empty:

Click OK.

If you wish to empty the cells again, remove the value you entered in this box. You can not do this by just deselecting the checkbox.

Refresh Data

When we change data in our table on which our PivotTable is based on, we need to manually update this PivotTable. This does not happen automatically.
Select the “Options” tab, in the “PivotTable Tools” and click the “Refresh” button.

If your “PivotTable” is based on an external database, we have some options.
Click the “Options” button in the “Options” tab, in the “PivotTable Tools”.
In the “Data” tab in “PivotTable Options” dialog that appears, check the box for “Refresh data when opening the file” and click OK.

This will automatically transfer data to your “PivotTable” and refreshes when it opens.

When we work a lot with the external data from our “PivotTable”, we can set the PivotTable so that it refreshes after certain time intervals.
Select the “Data” tab in the ribbon, and click the “Connections”.
In the “Workbook Connections” click the “Properties” button.
Check the box for the text “Refresh every” and enter the number of minutes.
You also have the option “Refresh data when opening the file”.
Click OK when you’re done.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats