There are two toolbars associated with using MIMICExcel: the MIMICExcel Add-in toolbar and the MIMICExcel toolbar.
The MIMIC Add-in toolbar appears in Microsoft Excel and is combined with the MIMIC menu:
The MIMICExcel Add-in toolbar contains two buttons:
| Button | Description | Function |
|---|---|---|
![]() ![]() | Enter MIMIC | Opens MIMICExcel. |
![]() ![]() | Refresh MIMIC Queries | Connects with the server and updates the data for all queries. |
The MIMIC menu includes three options.
| Menu Option | Function |
|---|---|
Enter MIMIC | Opens MIMICExcel. |
Refresh MIMIC Queries | Connects with the server and updates the data for all queries. |
Advanced Refresh Mode | Once selected, allows users to refresh MIMIC queries using specific start and end dates for either the active worksheet or for all worksheets. |
The MIMICExcel toolbar appears at the top of the MIMICExcel interface and contains three buttons.
| Button | Description | Function |
|---|---|---|
![]() | Back to Excel | Closes MIMICExcel. |
![]() | Query Manager | Opens the Query Manager, allowing users to edit, copy, rename or delete a query. |
![]() | Embed Query | Saves and embeds a query within MIMICExcel. |