Excel Pivot Table Datasource Change

[Shatneriffic]

Hello

We have a development and production regions for our oracle environment that support reporting in Excel pivot tables. How do we point our pivot tables in the development schema to the production schema without having to rebuild them from scratch?

Thanks!

 

[SkipVought]

Hi,

Activate the Pivottable Wizard, by selecting in the PT and right-click.

Select [BACK], [GET DATA]

In MS Query...

COPY the SQL

File > New and select your production database.

PASTE your SQL.

Edit > return data to Excel...

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}