Pivot Data Source Returns to Absolute

Frequent Contributor


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.



0 Replies