How to select a different sheet to update a Pivot Table

Xochitl Cerda · 12/15/20

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. · 12/16/20

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. · 12/16/20

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 · 12/16/20

https://community.smartsheet.com/discussion/comment/272099#Comment_272099

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!!

How to select a different sheet to update a Pivot Table

Best Answer

Answers

Categories