Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OLAP in EXCEL

Status
Not open for further replies.

Epervier9

Programmer
May 18, 2006
3
0
0
CA
I have a link to a cube un excel. And it works great. The problem is that I want my pivot table to point to another cube instead of the first one. Does someone knowk how to do that? By the way I use excel 2000 and SQL Server 2000
 
Very hard to do. There is a lot of metadata stored in the pivottable that is hard-defined regarding where it's data is coming from. Last year I started with offline cubes and VBA scripts to manipulate the pivottables connections. No dice, I had to rebuild the pivottables when I tried to switch sources

Ties Blom

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top