I've got a template file which will be copied and used everyday. I've got bunch of pivot tables. However, I'm encountering an issue which I haven't before. Pivot data source remains as the template file's pivot source.
I've got a table named RawOutput which I want to use as data source. But when I change it, the data source becomes absolute
How can I fix this?
I noticed this happens when I add the pivot to data model. However, I need to use that function.