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. 



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