MODLR Excel Add-In
You can download the latest version of the MODLR Excel Add-In [here]
- Workview Validations (Experimental)
When enabled in the Options menu, Workviews that define basic validations will now display those validations as dropdown lists directly inside Excel for easier and more accurate data entry.
- Handling of Invalid Workview Names
Workview names containing characters that Excel does not allow in worksheet names will no longer prevent the Workview from loading. Names are now automatically sanitized while preserving uniqueness.
- Resolved Ambiguous Element Issues
Workviews that previously failed to apply CubeGet formulas due to elements named the same in both columns and row headers should now process correctly without stopping the refresh.
- Live Workview Auto-Refresh on Selection Change
A new option, Refresh Live Workview on Selection, allows Live mode Workviews to rebuild automatically whenever a SelectionSet formula changes an element. This ensures structural changes like suppression should work.
- After-Refresh Worksheet Macro Support
You can now add a macro named MODLR_AfterRefresh to any worksheet. This macro will be executed automatically after a Worksheet or an entire Workbook is refreshed, enabling custom post-refresh logic or automation.
You can download the latest version of the MODLR Excel Add-In [here]
Last edited by a moderator: