How to select a different sheet to update a Pivot Table
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!
Best Answer
-
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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
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!!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives