How to Change Tabular Report App Connection and Tenant Address

Frank_S — Thu, 09 May 2024 19:21:05 GMT

It has become necessary to use an MS Excel Tabular Report in a different tenant.

Make a copy of the original MS Excel Tabular Report template file
Open the MS Excel Tabular Report template file
Click on the MS Excel Office Addin in the Excel Ribbon (Click on the 'alternate', 'new' tenant MS Office Excel Addin)
Log into the tenant (ensure all popup blockers are disabled)
In the add-in window, click the 'Home' tab in the toolbar
Next to Source app, click ...
From the menu, select Change template connection
In the Set the new Qlik Sense app ID field, enter the new app ID

(to find the new app ID, open the app in the 'alternate' or 'new' tenant hub and copy the app ID from the address bar
To change the tenant, enable the Change the Qlik Cloud tenant switch (disabled by default) and insert the new tenant address.
To save, click the Change Template Connection button
To use the changes, simply Click on the 'alternate', 'new' tenant MS Office Excel Addin again. This will re-log you in thus enabling the changes
Preview the report (select xlsx or pdf output format)

article How to Change Tabular Report App Connection and Tenant Address in Official Support Articles