Forum Discussion
Pivot Table creating new data source every refresh
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 wi...
It's not clear how that SQL query updates the source data--so maybe you could flesh that out a bit.
Specifically, does ALL of the data change each time?
Do the columns involved change?
I'm going to assume that when you say the "range size" changes, you mean that the number of rows change, but that the columns stay the same. I'm further going to assume that essentially you're adding new data (new transactions with new dates, or new something or others with new measurements associated)...
If those assumptions are accurate, let me ask if the data set is established as an Excel Table? If it is, and if it could be clear that you're just adding rows at the bottom, then it should be possible to just hit "Refresh Data" and have the Pivot Table work with a consistent name for the data source.
So tell me (along with anybody else reading this) how your situation differs from those things I asked about and assumed.
Specifically, does ALL of the data change each time?
Do the columns involved change?
I'm going to assume that when you say the "range size" changes, you mean that the number of rows change, but that the columns stay the same. I'm further going to assume that essentially you're adding new data (new transactions with new dates, or new something or others with new measurements associated)...
If those assumptions are accurate, let me ask if the data set is established as an Excel Table? If it is, and if it could be clear that you're just adding rows at the bottom, then it should be possible to just hit "Refresh Data" and have the Pivot Table work with a consistent name for the data source.
So tell me (along with anybody else reading this) how your situation differs from those things I asked about and assumed.