Forum Discussion
Prevent external reference in pivot Data Source
Hi, I'm trying to prevent external references being created in new copies of an existing spreadsheet. The issue seems to be limited to the Data Source for pivot tables. My spreadsheet includes var...
It sounds like you are on the right track with Big_Table being a structured table. Excel tables automatically adjust their references when you add or remove data, and they should ideally avoid the issue of external references. Ensure that all your pivot tables are consistently using the structured table reference.