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 your pivot tables are based on a table named Big_Table, one of the most effective ways to keep pivot tables updated without external references is to ensure that the source table (the "Big_Table") is consistently recognized by Exce.
Hi can you explain what you mean by 'ensure that the source table (the "Big_Table") is consistently recognized by Exce.'?
