This section is only relevant if you have built Excel reports before December 2014.


Our previous guide showed how to store the data source connection within the Excel workbook. We now recommend to link to a connection file hosted by Netminers. The advantage is that if we upgrade your database, you no longer have to change the properties of your connection.


To change data source to the hosted connection file, go through the following steps.

  1. Open the Excel workbook and click on your PivotTable or PivotChart to enable the PivotTable Tools:


  2. Select Analyze > Change Data Source > Change Data Source:


  3. Click Choose Connection:


  4. Click Browse for More:


  5. In the field File name enter the address of your connection file sent to you by Netminers Support and click Open:


  6. Click OK


  7. Repeat the above steps for each of your PivotTables / PivotCharts