How to select a different sheet to update a Pivot Table

Xochitl Cerda

Hi there,

I still learning with pivot app. I want to update one pivot table selecting a different sheet, in other words, I need to change the data source. Is that possible?.. When trying to update, I see the option to select a sheet is disabled.

Thanks in advance!

Genevieve P.

Hi @Xochitl Cerda

Currently there isn't a way to "swap" out the source sheet by editing a Pivot - you will need to create a new Pivot and select this other sheet as a new source instead.

You can learn more about the Pivot App in our Help Center, here, and you can submit feedback to our Product team on what functionalities you'd like to see, here!

Cheers,

Genevieve

Genevieve P.

Hi @Xochitl Cerda

Currently there isn't a way to "swap" out the source sheet by editing a Pivot - you will need to create a new Pivot and select this other sheet as a new source instead.

You can learn more about the Pivot App in our Help Center, here, and you can submit feedback to our Product team on what functionalities you'd like to see, here!

Cheers,

Genevieve

Xochitl Cerda

Genevieve P.

Dec 16, 2020

Hi @Xochitl Cerda

Currently there isn't a way to "swap" out the source sheet by editing a Pivot - you will need to create a new Pivot and select this other sheet as a new source instead.

You can learn more about the Pivot App in our Help Center, here, and you can submit feedback to our Product team on what functionalities you'd like to see, here!

Cheers,

Genevieve

Thanks for confirming @Genevieve P ! that's what I thought, so yesterday I created a new pivot table and I was able to refresh my data.

I will submit a request for enhancement. Many thanks for your help!!