Excel Pivot Source Data references Table WITHIN SAME workbook, changing to reference filename

I have an excel workbook with various pivot tables, all of which reference a TABLE (named Watts) that is located WITHIN the same workbook. There are no links to external data anywhere within the work...