Will VB mess with my links?

[DRANDON]

I have a workbook with several sheets all having multiple Pivot Tables. All PT's are linked to a table in an Access database. I want to be able to move these files around to different folders without having to manually change my connection string for each PT. However, I also have all subsequent PT's linked to the first PT's PivotCache on the first sheet to increase performance. I can vb my way through a loop to alter my connection strings (if and when I move files to a different folder) but will this screw up my linking all PT Caches to the first PT Cache?

Anyone??

Thanks in advance..

 

[Andrew Poulsom]

Duplicate:

http://www.mrexcel.com/forum/showthread.php?t=378678