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/c4lfagmxza...rformance.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