How to connect completed Excel Integration Files for Windows?

Open the file.
Click on the “Enable Content” button at the coloured bar at the top of the sheet, as shown below.
At the menu bar, go to the “Data” tab and click on the “Refresh all” button.
An “Access Web Content” window will pop up, and select the “Basic” button.
In the “Select which level to apply these settings to” dropdown, select the URL with “nod”.
Input the provided credentials in the window and click the “Connect” button.

⚠️ Note: For Excel Files: If the integration files contain Pivot Tables, click anywhere in the pivot table and at the menu bar, go to the “Pivot Table Analyse” tab. Click on the dropdown arrow next to the refresh button and click on “Refresh All”. Repeat the process if there are multiple pivot tables across different tabs to ensure all are following the updated data.
The integration file is now ready for use