Create a sheet "2015":
Create a sheet "pivot" und sum the amount:
Create a sheet "2016" with different data
Try to select the data from "2016" for the pivot table and hit the OK button and nothing will change...
Bonus: Create a new sheet with a pivot table and select the data from sheet "2016" and you will get the data from "2015".
I tried the same thing with Excel 2010 and it worked as expected (I get the data from "2016") and that is the way it worked for years in my sheets. I am curious to figure out if this is my setup/configuration or a bug.
EDIT: Similar question here.