Pivot Data Source Returns to Absolute

Contributor

Hello,

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

Filename.xlsm!RawOutput

How can I fix this?

 

Edit:


I noticed this happens when I add the pivot to data model. However, I need to use that function.

 

Thanks.

0 Replies