The My d6+ Excel Tools add-in embeds directly into Microsoft Excel, giving you quick access to d6+ data exports from within your spreadsheet. Embedding is optional but convenient. Macros must be enabled in your Excel installation for the add-in to function.

My Home > My Information > My d6+ Excel Tools

How do I configure the add-in in Excel 2007?

1. Click the Microsoft Office Button.

2. Click Excel Options.

3. Click Add-Ins.

4. In the Manage box, select Excel Add-ins and click Go.

5. Select the checkbox next to the latest version of My d6+ Excel Tools.

6. Click OK.

How do I configure the add-in in Excel 2010 or later?

1. Click the File tab.

2. Click Options.

3. Click Add-Ins.

4. In the Manage box, select Excel Add-ins and click Go.

5. Select the checkbox next to the latest version of My d6+ Excel Tools.

6. Click OK.

How do I enable macros in Excel 2007?

1. Click the Microsoft Office Button.

2. Click Trust Centre, then click Trust Centre Settings.

3. In the sidebar, choose Macro Settings and select Disable all macros with notification. This keeps macros off by default but prompts you when a macro tries to run.

4. Click OK, close Excel, and reopen it.

5. When the security notification appears under the ribbon, click Options, select Enable this content, and click OK.

How do I enable macros in Excel 2010 or 2013?

1. Click the File tab.

2. Click Options.

3. Click Trust Centre, then click Trust Centre Settings.

4. In the Trust Centre, click Macro Settings and select your preferred option.

5. Click OK.

Note: Macro settings apply only to the Office programme you are currently using, not to all Office programmes. If settings are greyed out, your system administrator may have restricted changes.

Frequently asked questions

The add-in is not working after I enabled it — what should I do?

Try refreshing the worksheet first. If the issue persists, ensure macros are enabled and that you selected the correct (latest) version of the add-in in the Add-Ins list.

Do I need to install the add-in to use d6+ Excel exports?

No. Embedding the add-in is optional. You can still export data from d6+ to Excel without it — the add-in simply makes the process more convenient by embedding tools directly in Excel.

My macro settings are greyed out — why?

Your organisation’s system administrator may have locked macro settings. Contact your IT administrator to enable macros for your user profile.