Viewing OLAP datasouce of pivot table

[arrowhouse]

I'm new to pivots with olap & need to check the OLAP source of a sheet that was created by somebody else. If I go into the pivot table wizard the back button is greyed out so I can't see how the OLAP is defined. Is there another way I should be looking or I'am I missing something?

Thanks

 

[SkipVought]

arrowhouse,

You must have a cell selected within an EXISTING PivotTable.



Skip,

http://www.TheOfficeExperts.com

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

 

[arrowhouse]

I do... any other suggestions?

Cheers

 

[SkipVought]

Then, I would assume there is no data source defined. The apparent OLAP is merely a copy of OLAP results.

Skip,

http://www.TheOfficeExperts.com

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

 

[arrowhouse]

But when I look at the layout I can see things like connecting to OLAP appear in the status bar (but irritatingly not where the location is!

When I refresh I'm getting new info in each day. Would this happen even for an 'apparent' OLAP?

Cheers for your suggestions - do you have any other ideas on this?

Thanks

 

[SkipVought]

It does sound like it IS connected. I am at a loss! Sorry.

Skip,

http://www.TheOfficeExperts.com

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

 

[arrowhouse]

Thanks for your time Skip, I'll post again if I find a solution.

Cheers

 

[HappyMoose]

arrowhouse, skipVought

Arrowhouse I have posted this problem before, I see that you added a rely to it.

I been working on this off and on for a while. Here is what I have found out.

In my case I know what datasource (OLAP Cubes) my pivot tables are pointing to. This information is stored in the default datasource directory. documents_&_settings\user\Application Data\Microsoft\Queries. You can open these queries in notepad and change the details if you require.

Problem - Its like excel caches the details because it ignores the changes to the datasource (queries). Big pain in the backside. Especially when you cant change the cube names either.

But it does appear that if you move the spreadsheet containing the pivot table to another machine and it does not have the same Analysis server and cubes, it wakes up so to speak and askes can't find [old datasource] give details for the new datasource (cube) you want to connect to.

While this does not necessarily help you some of the information might help to allow you to find what cube the pivot table connects to.

Keep in touch I want to find an answer to this. Looking at using vba connection strings so that you do have control over the datasource.


HappyMoose
Australia