Change the data source link of an Excel table

If you take a Excel spreadsheet from another system you have to customize the HTTP address of the datasources because the server of the generating system had another HTTP address.

The pictures in this document were created with a German Excel. We will change that if we get access to a US Excel.

The datasource refers to a favorit in the BVQ database. You probably have to import it first.
The favorite can also be a system favorite which belongs to the base installation.

Do I need to import a favorit first? ...

You can see that on whether the word system is at exactly this point in the access path. In all other cases, you need a special favorite that needs to be imported.

Changing the datasource is simple:

(1) Open the Datasources in your Excel spreadsheet

(2) Open the DataSource and edit the first entry.
Here you see the URL that needs to be customized.
I recommend this to get this string from the BVQ server and not edit it. Use a datasource to connect to ITSM