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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.