Hi
My dashboard file is connected to 02 master excel
Files via data connection , dashboard excel file
Builds pivot table and pivot charts and use the data
In these 02 master excel files .
Now due to some changes in our department
These master files will be located to other
Location , new directory and perhaps the
File name will be changed as well, now my
Concern is how do i change the location
In my data connection , is it like simply setup
New connection and delete the old connection
Or can I edit the location.
2nd question is by changing the
Location and establishing new connection , will
That muck up alll my pivot charts and tables , because
If it does then I will be in trouble , please
Advise. Need your help.