Hi all,

Is any of below two actions possible?
  1. Change pivot source from table/range to connection:
    HctNF.png
  2. Change pivot to power pivot without loosing calculated fields, etc.


I adjust data in Power Query and then load these queries as tables into sheets. That's the source for my pivots. I have plenty of it. With conditional formatting, calculated fields, etc. I don't want to build it from scratch, I don't need to load data to sheets. What's more, I though about collecting historical data in access data bases, then load it to Power Query (but not to Excel sheet!) to have it as pivot/power pivot source, because there will be more data than Excel can have.

Is there a simple solution how I could convert it? Or I'll need to build pivots from scratch?

I'd be really grateful for your answers.