File Save As Changes Pivot Table Data Source to Absolute Address

Question

Excel 2013 (15.0.4797.1000) on Windows 8.1 Enterprise 64 bit OS

Created Pivot table and set source data to local sheet in workbook.  Save workbook to local document folder and then open workbook and data source still points to local data in workbook.  Do a Save As to another file name in local document folder, open new file and the data source has been changed to an absolute address pointing to the old file name.

Implications of this behavior are:

-- First you get a Security Warning  External Data connections have been disabled. 

-- Second the pivot table is not pointing at the correct data source so when the data in the current workbook is update the pivot table data is not accessing current data.

Original local data source:  'Normalized QuIX Data'!R6C1:R10000

After Save As data source: '[V3.0 Wednesday Defect Detail List 03302016.xlsm]Normalized QuIX Data'!R6C1:R10000

Answer 1

Hi,

Since, your issue is related to Pivot table, I kindly suggest you to post this in the following Office TechNet forum for better suggestions.

I kindly request you to post this query in the following TechNet forum for better suggestion.

https://social.technet.microsoft.com/Forums/office/en-US/home?forum=excel

Thank you.