Changing SQL Cube excel pivot tables are pointing to

[HappyMoose]

I have built an excel (2000) spreadsheet containing 6 differently formatted pivot tables. By going data >> pivot tables >> external data >> OLAP cubes.

I want use the same spreadsheet for another SQL cube on a different data source.

Is there way to do change the SQL cube that the spreadsheet is pointing to. All the help files only talk about using the MS Query cube tool.

Or do I need to set it up differently

Cheers

HappyMoose
Australia

 

[SkipVought]

Hi,

With the PivotTable selected, activate the PivotTable Wizard and use the Back button to get to the place that you specify the data source.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[HappyMoose]

SkipVought,

Thanks for the reply, but when I highlight the pivot table (the outside of the data gives a blue line) and click on the pivot table wizard, it gives me the Step 3 of 3 dialogue screen [Where do you want to put your pivot table] and the back button is greyed out.

Is there anything else I need to do to make the back button available.

Thanks again

HappyMoose
Australia

 

[arrowhouse]

I have the same issue - the back button is greyed out. Gan anyone enlighten me? I'm new to pivots with olap & need to check the OLAP source of a sheet that was created by somebody else


Thanks

 

[SkipVought]

arrowhouse,

Please post your question in a new thread.

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884