Pivot Table Range Names

1. How To Create Dynamic Pivot Table In Excel

Sep 13, 2017 - Since the pivot table(s) reference the Table name as source data range, instead of a range reference, the new data is automatically included in.

Hi,I am using Excel 2013 on Windows 8I create a table, and insert a pivot table that use this table as data sourceI close the excel and rename the file from 'myfile.xlsx' to 'newfile.xlsx, and then open it againWhen trying to refresh my Pivot Table, I get the following Error:'We couldn't get the data from 'Table1' in the workbook 'C:myfile.xlsx' Open this workbook in Excel and try again.' It is still looking for table using the old file name.I need to update the file every week, so having to manually go back and change source file name for every pivot is very time consuming and painful for me:-(Please investigate and advise how to fix this? Hi,Based on my tested in my environment (Window 8.1 & Excel 2013), the error message pop up when a pivot table using an external data source. If you use the table as external data source, pivot table uses OLEDB to connect it, it'll refresh failed afteryou changed the file name. It's by design.Then, we may try the two workaround to avoid it:1) Keep the data source table and pivot table in the same file.2) Add the table to a connection, steps:Click Data tabConnection Add Browse more Choose the file.Please try to change in new file in property before you refresh the Pivot table.Regards,George ZhaoTechNet Community SupportIt's recommended to download and install, which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Officeprograms.

Hi,Based on my tested in my environment (Window 8.1 & Excel 2013), the error message pop up when a pivot table using an external data source. If you use the table as external data source, pivot table uses OLEDB to connect it, it'll refresh failed afteryou changed the file name. It's by design.Then, we may try the two workaround to avoid it:1) Keep the data source table and pivot table in the same file.2) Add the table to a connection, steps:Click Data tabConnection Add Browse more Choose the file.Please try to change in new file in property before you refresh the Pivot table.Regards,George ZhaoTechNet Community SupportIt's recommended to download and install, which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Officeprograms. I have this same problem, however I am changing the file name by 'save as' (not externally in the folder). I am just changing the file name with the V2, V3, V4 or changing the file name to have a different date extension (20150522 to 20150529)I just changed from MS Office 2010 to 2013 and this problem started.I built out a spreadsheet with multiple tabs of pivot tables all referencing the master data tab in the same spreadsheet (any external data is Index-Match function into the spreadsheet and then copy-paste values.When I 'save as' the document as a new name, the pivot tables all refer back to the old document. Not sure why this is happening and it is very frustrating and time consuming to update the data ranges.Is this a MS 2013 bug?

Is there any way to lock down the data reference fields to stay in the document and not try to refer externally?Thanks. Hi both,I have exactly the same problem, however the fix outlined by George does not work for me.I am using MS Excel 365 on a PC. The Excel file is saved to and opened from OneDrive.

How To Create Dynamic Pivot Table In Excel

I saved an earlier version of the file under a new file name. Now, wen trying to REFRESH the new Excel file the above error message appears, mentioning the old file's filename.Please note: the data table in my case is already in the same file as the pivot table.

When I look for any connection to the earlier (old) file in my new Excel file, NO CONNECTIONS are found. I do not think it would make sense to create a connection as statedabove within one and the same file.wouldn't it?Thanks for any support!Best, Ralph.