Pivot Tables

[bnoc8418]

I have a pivot table that doesn't seem to be refreshing when a new row is added in the reference table.

I've tried:
- Refresh all
- Refreshing / Changing data source (data source is a table and not a range of cells so I know the row isn't missing from the selection)
- Removing filters on the pivot table and re-filtering

What am I missing here, I've never had this problem with a pivot table before.

[dilipandey]

HI Bnoc,

That's interesting...!!
As a option, check if the row which you are inserting already exists and the sum/average column has blank... thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[bonny24tycoon]

Hi Bnoc,

Once you single click on the pivot > goto Pivot Table Options where you can also see (Home/Insert/Review, etc), Just click Change data source and then ok..

Screenshot attached for your assistance. Doc1.docx

You should be good to go then.


Thanks,

Bonny Tycoon



**If I was able to help please click the small star icon at the bottom left of my post **

[bnoc8418]

Anything else, I have already tried both of these suggestions with no luck.

[dilipandey]

Ok.. please upload the sample workbook. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>