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
Help Needed on TM1 Active Forms issue
-
- Community Contributor
- Posts: 109
- Joined: Thu Feb 26, 2009 8:44 am
- OLAP Product: TM1
- Version: 9 + 10 + Plan An
- Excel Version: All
- Location: Isle of Wight, UK
Re: Help Needed on TM1 Active Forms issue
Has the user got macro security set to disable all macros?
"the earth is but one country, and mankind its citizens" - Baha'u'llah
- gtonkin
- MVP
- Posts: 1211
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Help Needed on TM1 Active Forms issue
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
To solve I removed MSForms.EXD from %Temp%\Excel8.0
-
- Posts: 19
- Joined: Thu Jul 12, 2012 4:34 pm
- OLAP Product: IBM Cognos TM1
- Version: 10.2.2.4
- Excel Version: 2010
Re: Help Needed on TM1 Active Forms issue
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.
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.