Calculate Field in pivot table not updating when adding new data into a table range

**Debron101** · 12-04-2019, 03:02 PM

I have a pivot table that has 3 calculated fields and when I initially set up the pivot table all calculations worked.

When I have come to added new data into the data range the pivot table isn't adding any of the new data set.

The data source is including the new cells in its range.

Regards

**Pepe Le Mokko** · 12-05-2019, 03:47 AM

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Calculate Field in pivot table not updating when adding new data into a table range

LinkBack

Thread Tools

Rate This Thread

Display

Calculate Field in pivot table not updating when adding new data into a table range

Re: Calculate Field in pivot table not updating when adding new data into a table range

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Adding a data field to a pivot table - runtime error

Adding up field in Pivot table and Difference between Add Measure and Calculated Field

Adding additional columns inside a pivot table to calculate rates from pivot table

Adding field to calculate sum of a field and count of a field in pivot table

Excel Pivot table has 2 field headings from same data but 1 is not updating

Updating pivot table field list

Adding to Pivot Table data range

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions