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..
Anyone??
Thanks in advance..