Hello

I have a pivot table which is based on an analysis services OLAP cube.
I have a lot of excel sheets which are based on the old cube, and now I have moved the cube to another server.

Is there an easy way to change the data source of a pivot table, so that I don't have to remake all my excel sheets?

Thanks in advance