I have the following code to refresh a bunch of pivot table caches. For whatever reason, everytime I save and increment the file, the caches keep pointing back to the old file. I can get this to work for one pivot table but not all through the workbook. Any advice?
Sub...