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...
Since you mentioned that switching to a dynamic named range leads to issues where pivot table data sources revert back to the table name, consider avoiding named ranges altogether. Rely solely on the structured table references (like Big_Table) for the pivot tables.