ExcelBanter - Pivot Tables - Missing Data after refresh

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Pivot Tables - Missing Data after refresh (https://www.excelbanter.com/excel-worksheet-functions/98094-pivot-tables-missing-data-after-refresh.html)

Gr8Day

Pivot Tables - Missing Data after refresh

I have several pivot tables in one worksheet and I add data monthly. After
adding data this month, expanding the range and refreshing each pivot table
something odd happened. Some of the tables show data for the new month and
some don't. However, when you click the arrow, the month is selected. Any
ideas?

All times are GMT +1. The time now is 02:02 AM.