Knowledge Base
Zebra BI for Excel

Update data in pivot tables

Applies to:
Zebra BI Tables for Excel

Template used: Income statement

In the following article, you will learn how to reflect a data update in your pivot table following a few simple steps. Two cases will be explained, using a regular data range as a source, and using an official Excel table (recommended).

Range source

Let’s consider a pivot table on the right from the source on the left, and an Excel range:

A pivot table (right) from an Excel range (left)

Let’s add a new row for Deferred taxes.

Adding new rows of data

Note that it is not reflected in the pivot table yet. To reflect it in the pivot table, follow the next steps:

  • Click inside the pivot table
  • Navigate to PivotTable analyze tab
  • Click on Change Data Source
  • Include the new row in the source
Change the pivot table data source
Source range selection

Include the 22nd row in the pivot table source. Click OK and Yes.

Include row 22 in the source range
Click Yes

The deferred tax row is reflected in the pivot table:

Deferred tax included in the pivot table

Excel table source (recommended)

If you are using an Excel table as the data source, it is much simpler to reflect your new data in the pivot table and consequently in the Zebra BI for Office add-in. Therefore, it is the recommended data source for using the add-in.

Firstly, reflect your new data, Deferred tax, in the Excel table:

The data will be reflected after the pivot table refresh.

Right click on the pivot table -> Refresh to reflect the data in the pivot table and the Zebra BI Tables for Office as well.

In summary, updating pivot tables is a regular straightforward procedure. You now know how to update them both in ranges and Excel tables. Noting that using Excel tables is recommended for convenience and simplicity compared to ranges.

Was this article helpful?