I am having an issue with the dates not saving when I "refresh all" or if I close the workbook, it reverts back to a date in the past.  I can toggle back and forth between past date and latest date (yesterday), so that is consistent.   This workbook has 34 worksheets that have dependency on this date that is changing.  I create a new file which is a 'distributon' from this file and with the incorrect date, all of the data is incorrect.

 Also, there are 7 sheets with pivot tables.  When Excel picks up the date-I have filters on the 'date_hour' field in pivot table is in Column; and 'GW' is the gateway number to match the date in the row labels. All components of the workbook work correctly if the date is correct--otherwise, most of the worksheets are incorrect with the incorrect date.  

I have tried everything and cannot figure this issue out. I have read so many blogs-my head is swimming!  Please help! 

Just a thought. Do you have links to another workbook (or template) from where it is getting the dates and the date in the source is not being changed.?