My pivot tables are completely resetting when changing external connections, even when the data structures are identical. It works fine for data within the workbook, but external connections. From what I've researched I should be able to do this without completely rebuilding my pivot tables. Am I missing a step? Is there a workaround?
