TM1 Forum

Hello friends,

We have excel template (active form) with some Action buttons and Macro buttons. The existing users have no issues with accessing or recalculating template.
However a new user who just joined team is facing some issues.
The user can successfully open the template and refresh(recalculate) the data. But whenever if user makes any change to data like using picklist or types data and click on recalculate, the template doesn't do its job. It neither recalculates the data and no buttons will respond. which is a weird issue I encountered.
Can someone help me in fixing this issue?

Environment details:
Users open templates from applications folder in Perspectives. Templates are added as references. TM1 version 9.5.2. Excel 2010. Template extension: .xls.

Thanks
Kumar

Has the user got macro security set to disable all macros?

I had a similar issue recently after an Office update. My form control button no longer worked but same template worked on other machines.
To solve I removed MSForms.EXD from %Temp%\Excel8.0

Thanks for your inputs.
We finally resolved the issue. The issue is that user is sorting the rows in active form and trying to refresh.
Because of which template is not refreshed as expected.