Pivot Table and Chart Not Showing New Data

rob51852

Board Regular
Joined
Jun 27, 2016
Messages
159
Office Version
  1. 2016
Platform
  1. Windows
Hi,

I have a pivot table and chart linked to a named table which imports data from an Access database. It was recently refreshed but the new data isn't showing in the pivot table or chart (the old data is still there).

It is showing in the slicers I have but is greyed out and when I select them the chart contains no data.

I have tried refreshing the pivot table but that hasn't helped.

Can anyone think what the issue is?

Thanks
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,819
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
I'd double-check the source data for the pivot table is still what it should be.
 

rob51852

Board Regular
Joined
Jun 27, 2016
Messages
159
Office Version
  1. 2016
Platform
  1. Windows
Hi Rory,

Thanks, the source data is the correct table.
 

rob51852

Board Regular
Joined
Jun 27, 2016
Messages
159
Office Version
  1. 2016
Platform
  1. Windows
This is very strange... I have tried to recreate the pivot table, chart, etc in a new workbook and I get exactly the same issue.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,819
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS

ADVERTISEMENT

Can you post the workbook somewhere for me to have a look at?
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,819
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS

ADVERTISEMENT

It looks ok to me after refreshing. Can you give me a specific example of what is wrong?
 

rob51852

Board Regular
Joined
Jun 27, 2016
Messages
159
Office Version
  1. 2016
Platform
  1. Windows
Hi Rory, the slicers are greyed out for the new data and when I select one the chart is blank. See attached. Thanks
Untitled.png
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,819
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Clear all the slicer filters first.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,754
Messages
5,574,040
Members
412,565
Latest member
roberttaekim
Top