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?