New Pivot Table Displaying Old Data

[johnallen876]

Hi all,

I have a cost breakdown for a construction job and for each draw request, I create a separate sheet with those costs for that period, and create a pivot table with that data on each sheet. It has been working out well thus far, but I'm having a problem with my most recent pivot table: I select the data and create a new pivot table, like always, except it uses data from a different sheet. I can't seem to find the glitch or the issue, perhaps someone can help? I have provided the sheet in this dropbox link, and saved the most recent table. I created the pivot table on sheet "draw 8 - 08.07.17" with the data from that sheet, but it's using the data from sheet "draw 6b - 07.23.17"

I need to get this resolved quickly, as I process weekly draws. Thanks!

https://www.dropbox.com/s/1wl7c4hysj...dule.xlsx?dl=0

[sandy666]

Duplicated post
answered here: https://www.excelforum.com/excel-gen...-old-data.html