In MIMICExcel, query results are tabled to an Excel spreadsheet. Users can refresh or update the query results. When refreshing, MIMICExcel connects to the server and receives the latest data, and then replaces the old data in the Excel spreadsheet with the new data. MIMICExcel refreshes the results for all embedded queries.
To refresh the queries, users can select MIMIC>Refresh MIMIC Queries from the Excel menu
bar, or select the Refresh MIMIC Queries
button from the MIMICExcel
Add-in toolbar.
MIMICExcel has advanced refresh options which allow users to indicate a specific start and end date for a query, and if the the advanced refresh options apply to the active worksheet, or to all worksheets.
To use the Advanced Refresh Options in MIMICExcel, users must first select MIMIC>Advanced Refresh Mode from the Excel menu bar. Once selected, this option is indicated with a check mark in the MIMIC menu. Then, users can select MIMIC>Refresh MIMIC Queries. The Advanced Refresh Options window displays, where users can modify the start and end dates for the queries, and specify that the advanced options apply to the active worksheet or to all worksheets.