How to change pivot table data source in Excel?

excel business-intelligence xls pivot-table
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.

Related questions

Package Validation Error

I'm trying to use a foreach loop container to import several excel files into a table, I specified the folder and the files I'm going to use (*.xls), after that I created a path variable then I went to the …

Read More
Dynamic sum in dax picking distinct values

Below is sample data Week Practice Type capacity Gen 1 BI c 80 0 1 BI c 80 1 1 BI sc 160 1 1 BI pc 240 0 1 BI pc 240 3 1 BI mc 1160 1 1 BI mc 1160 4 1 BI mc 1160 2 1 BI ac 440 1 1 BI d 40 0 1 BI d 40 3 I have a pivot chart, that has 3 slicers namely …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More