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
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