How to change pivot table data source in Excel?

adolf garlic  picture adolf garlic · Apr 7, 2009 · Viewed 138k times · Source

I want to change it from one database to another.

There don't appear to be any options to do this on the pivot table context menu

Answer

Zoe picture Zoe · Aug 11, 2010

Just figured it out-click anywhere in the table, then go to the tabs at the top of the page and select Options-from there you'll see a Change Data Source selection.