Step 3. Install the Sample Reports using Microsoft Excel 2000

  1. Open Microsoft Excel.

  2. Click File on the Microsoft Excel menu bar.

  3. Select Open.

The Open browser opens.

  1. Find the Report folder in the CIMPLICITY \directory.

  1. Open a report that is compatible with your version of Microsoft Excel.

A message box appears asking you if you want to enable the macros.

  1. Click Enable Macros.

The selected report opens.

  1. Click Tools on the Microsoft Excel menu bar.

  2. Select Add-Ins…

The Add-Ins dialog box opens.

  1. Check MS Query Add-in.

  2. Click Browse to select the XLODBC.XLA add-in path:

C:\Program Files\Microsoft Office\Office\Library\MSQuery.

  1. Replace any existing XLODBC.XLA add-in, if you are prompted to do so.

  2. Save your updated report.

  3. Repeat these steps for all three report files. You will need to do this only once for each report.

  4. Click OK.

More information


All steps for installing MS Query to use with Database Logger.