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

 

[MGadAllah]

Or this one
https://dl.dropboxusercontent.com/c...533kiJ7kXJOA5FWQMFqKUb0pQ1ERGgy11bSZHrpT?dl=1

 

[Andrew Poulsom]

I don't want a rar. Upload a smaller workbook. The URL in Post #11 isn't working.

 

[MGadAllah]

I don't want a rar. Upload a smaller workbook. The URL in Post #11 isn't working.

Ok Try ths one

https://www.dropbox.com/s/uczs3mdpdlvjwlk/Employee_Performance.xlsx

Data Source is Table1 in Data_Entry worksheet

94kb

 

[MGadAllah]

were you able to open or download the file?

 

[Andrew Poulsom]

In that workbook the pivot tables source is in an external workbook:

'\Users\MohamedGad\Desktop\New folder\Employee_Performance.xlsx'!Table1

Why can't you change it to just Table1.

 

[MGadAllah]

In that workbook the pivot tables source is in an external workbook:

'\Users\MohamedGad\Desktop\New folder\Employee_Performance.xlsx'!Table1

Why can't you change it to just Table1.

It is already the table1 in the 1st worksheet in the same work book that is titled DataEntry
Have you tried to change it? does t accept?
please help

 

[Andrew Poulsom]

Yes, I could change the source to Table1.

 

[MGadAllah]

Yes, I could change the source to Table1.

My question is:-
If you changed th place of the file by movng it to another place, does it stll working?
or even if you renamed it, is it still working?
and why it does not keep data soure s table1 only and not the ull path of the file?

 

[Andrew Poulsom]

If the source is in the workbook there won't be a problem moving it or saving it with a new name/folder.

 

[gerotutu]

If the source is in the workbook there won't be a problem moving it or saving it with a new name/folder.

It exists this problem. Many people have had it. Everytime the file is renamed the data source kept related to the first file.