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 Chriss Miller 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
Joined
May 18, 2006
Messages
3
Location
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