Help Needed on TM1 Active Forms issue

Post Reply
VPKR
Posts: 19
Joined: Thu Jul 12, 2012 4:34 pm
OLAP Product: IBM Cognos TM1
Version: 10.2.2.4
Excel Version: 2010

Help Needed on TM1 Active Forms issue

Post by VPKR »

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
iansdigby
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

Post by iansdigby »

Has the user got macro security set to disable all macros?
"the earth is but one country, and mankind its citizens" - Baha'u'llah
User avatar
gtonkin
MVP
Posts: 1192
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

Post by gtonkin »

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
VPKR
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

Post by VPKR »

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.
Post Reply