Problem reestablishing link to OLAP data source from Excel Pivot table

R

Raj

We recently updated our OLAP cube on the production server with a new
version (version 2) of the cube (cube name remaining same). Since then we
cannot refresh all our older pivot tables which were created using version 1
of the cube. Cube name remaining the same, we thought this was possible
since while creating a new link through Excel to an OLAP data source to
build a pivot table, we only need to specify the server and the cube names.
Our problem is in re-enabling refresh on several pivot tables created using
version 1 of cube, without having to recreate them from scratch. Thanks.

- Raj
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing OLAP Pivot Table Connection Source 0
OLAP Pivot Table 1
Refresh CubeFields for existing Pivot Table on OLAP cube 1
Excel 2007 pivot table using analysis services cube as data source 0
Pivot table from olap cube Warning and datasource 0
Pivot table hierarchical dimension expansion 0
Change the data source of a pivot table 1
Pivot Table accessing data from OLAP cube 0

Top