Mar 17 2021 02:29 PM - edited Mar 17 2021 02:30 PM
Just like the title says I have a pivot table linked to a dynamic data source (sql query) that changes in range size on sheet1 and on sheet2 a pivot table that is just used to format the same data with subtotals and totals etc.
every time I refresh the pivot table it creates a new data source "CompanyData2" witht the number incrementing and the data won't change on the pivot table cause obviously now it's linked to the new data source which is totally different. Is there a fix for this?
Thanks!
Mar 17 2021 03:17 PM
Mar 18 2021 07:42 AM
okay I attached a screenshot of the data sources, picture 1 is the datapage and pivot table is the pivot table, when I first created the pivot table I told it to get the data from the existing CompanyDataNew table and when I refresh it makes it own with a new number and the other one doesn't do that.
Mar 18 2021 09:33 AM