In Excel, we will link our file to the Cadulis data source.
This way, in Excel, a simple click on the “Refresh Data” button will update the Excel sheet with real-time data from Cadulis.
On the data source configuration page, you can directly download the .iqy
file.
By opening it with Excel, it will automatically set up a connection to the Cadulis data source.
Depending on your version of Excel, you may need to load the data source manually:
Data > Get Data from Web
Now that our data is in Excel, a click on Refresh All
in the Data tab will update the Excel sheet with data from Cadulis.
Now you can create the most amazing pivot tables and charts!