We are currently upgrading to SQL 2005. We have many users who have setup
excel pivot tables accessing AS2000 cubes via oqy files. I would like to have
the pivot tables point to our new AS2005 cubes. They have identical
dimensions & members except for where there are hierarchies. eg
[Time].[Calendar] will be [Time Calendar] in AS2005.

Is there a utility which I can run to amend those pivot tables to point to
the AS2005 cubes? Or is there ADO.MD script which i can run?