At times a user will run into an issue when trying to use a macro for filtering the data coming from an Excel sheet. When using the curr macros Excel does not relate the data back to a proper Excel Date format and will give you an error similar to below.
An error occurred while retrieving the data for the
chart : [Microsoft][ODBC Excel Driver] Data type
mismatch in criteria expression..
The cause of this issue is the Microsoft Excel Driver handling of the data conversion.
When adding your curr macro to the filters add them like shown below, this will handle the conversion for you so that the issue does not come up.
All you will need to change is the macro type, and the integration between the Excel driver and iDashboards will work smooth.