Home

Pivot Table - unable to refresh new data

handsome boy
Occasional Visitor

Hi, new data are added into the table in excel when it doesn't get refreshed when click on the refresh button of an existing pivot table. It works when I create a new pivot table. Why is it so?

1 Reply
Highlighted

If you use Refresh All that could if such option is disabled in connection properties (if you added to data model)

image.png

 

Related Conversations
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Pulling data from one tab to another
krysphares in Excel on
6 Replies
Set Auto Refresh to Pivot Table as Source Data Changes
ratishkp in Excel on
2 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies