title: Excel Pivot Table data source after file name change, refers to previous file name
body: <p>I have an excel workbook with several pivot tables referring to data contained in the workbook. All data referred to by the pivot tables are contained within this workbook ("Version 1").</p>
  
  <p>I would like to rename this workbook as "version 2", but when I rename the workbook, all the pivot tables refer to the "version 1" data. I want the pivot tables to refer to the data in "version 2".</p>
  
  <p>I have tried several combinations of option settings, but I cannot find a combination of settings that automatically changes the pivot table source references to the newly named "version 2".</p>
  
  <p>I understand that could write a vba script to solve this issue, but I want to know if there is a non-vba solution. </p>