How to set data source for pivot table permenant even if file name or path changed in case data source is already within the same workbook

[MGadAllah]

Hi,
The pivot table I am making contains data source that is already existing in the same file.
As soon as file name changed or file path location changed , the pivot table no longer working and as soon as I do any refresh in the pivot able it is reporting a error that data source does not exist.
I've tried several ways as set data source as a table but no way.
This is the file:-
https://www.dropbox.com/s/c4lfagmxzae0meo/Total_Employee_Performance.xlsx
So how can I make or set data source to be permanent so in case file renamed or copied from place to another ... pivot table still works.
Thanks

 

[Andrew Poulsom]

I can't download your workbook, but if you select the pivot table and click Change Data Source in the Date group on the Ribbon's PivotTable Tools Options tab what is in the Table/Range box?

 

[MGadAllah]

I can't download your workbook, but if you select the pivot table and click Change Data Source in the Date group on the Ribbon's PivotTable Tools Options tab what is in the Table/Range box?

Thanks for the fast reply.

https://www.dropbox.com/s/c4lfagmxzae0meo/Total_Employee_Performance.xlsx
https://www.dropbox.com/s/c4lfagmxzae0meo/Total_Employee_Performance.xlsx

Please try these links.

The problem for me is not how to change the data source for pivot table but the problem is how to make the data source (which is the sheet Data_Entry in the same workbook file) permenant so in case file has been renamed or changed the file location path , I want pivot table to still work.

This file is a template for the survey department in call center and they do about 4 or 5 surveys per week and each workbook must be renamed and saved in a separated place so you can imagine how importance is keep the data source permanent

 

[MGadAllah]

- later edit -
I tried to type it like that but no chance,
Table1
Data_Entry!Table1
But as soon as I close the file and rename it or change location it does not work and data source need to be reselected.
Also I tried to edit the option of the pivot table like here:-
Pivot Table Option > Data Tab > PivotTable Data > Save Source Data With File.
check or uncheck the box but no differences.
Still have the same problem.

 

[Andrew Poulsom]

The Download button in Dropbox isn't responding. can't you post the PivotTable's source data details?

 

[MGadAllah]

Try this one
Total_Employee_Performance
Total_Employee_Performance

The Download button in Dropbox isn't responding. can't you post the PivotTable's source data details?

 

[Andrew Poulsom]

Can't you share a smaller version of your workbook?

 

[MGadAllah]

I do not know how to do so.
But are you still not able to download it?
What is the mirror you can access so I can upload it ?
I added links for the file @dropbox and @mediafire

 

[Andrew Poulsom]

It seems that the workbook is too large to download. Delete some rows to make it smaller.

 

[MGadAllah]

It seems that the workbook is too large to download. Delete some rows to make it smaller.

Ok, here you are
https://www.dropbox.com/s/l3hr5um1c7bhwqr/Total_Employee_Performance_[30-06-2014]_[17-40-49].rar