Excel Pivot linked to Access database

[Bowlnhokie]

I currently have an excel pivot table linked to an access database. They are in a folder called Time01. Next months I want to copy the datbase and excel file from Time01 into a new folder called Time02. Does anyone know if my pivot table in Time02 will be linked to my access database in Time01 or Time02?

Is there a way to see the full path of the database that the pivot table is linked to?

 

[xenou]

It appears your link will still be to the address of the original database.

Some help in dealing with this from MrExcel MVP Fazza:
http://www.mrexcel.com/forum/showthread.php?t=315657&highlight=immediate+window

Another suggested refinement here:
http://www.mrexcel.com/forum/showthread.php?p=1575932&posted=1#post1575932

Backup your originals and test the move first.
AB

 

[Bowlnhokie]

Thank you for your help