Changing data source of OLAP cube

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

The location can be edited in Microsoft Script Editor. This can be opened with ALT/SHIFT/F11 key.