I have an .ODC query file in Excel that pulls the data via pivot table from a data base. I copied the tab from one workbook to another and now I am getting an error the pivot table is referring to the previous sheet. Since its a query connection it shouldn't matter as the raw data is not in the excel file.
Where do I update the reference of the pivot table to point to the current workbook/sheet?
Where do I update the reference of the pivot table to point to the current workbook/sheet?
