Pivot Table not updating

New Contributor

I have a pivot table that is not refreshing correctly. It is only picking up the first 4 weeks of data and the grand total (5 columns in total) 

 

All the data is available in the file to refresh the table but not it is not updating all the additional weeks despite refreshing the table. 

 

Bernadette1977_0-1656462900896.png

This table in turn feeds into a chart 

 

Any suggestions will be greatly appreciated 

2 Replies

@Bernadette1977 You didn't show the data itself, but are you sure that the source for the pivot table includes the new data?

it is now finally working - it was not working previously