April 18, 2007 at 8:33 am
I have a pivot table in an excel file which has a cube (analysis services) as data source.
How can I change the name of the cube in my file excel? I want to change the data source of this pivot table (to another cube with the same structure but different members).
Where can I see the name of the data source? Is it possible to do this?
Thanks
April 19, 2007 at 1:35 am
you can try this
right mouse click the pivot table, select pivot table wizard
once the wizard comes up select the back button , then select get data tab
u can change the data source here...
April 19, 2007 at 2:46 am
The back button isn't enable....
I think it's possible to do this only if I have a query as data source and not Olap Cubes....
April 19, 2007 at 8:23 am
I've found a solution....
It's ok if I save the file Excel as Web Page , then modify the name of data source with notepad and save again. Then I open the file with Excel and save it as .xls
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply