Action Button Functions Stopped Worked

Post Reply
dubs
Posts: 131
Joined: Fri May 22, 2009 10:43 am
Version: 9.4
Excel Version: 2003

Action Button Functions Stopped Worked

Post by dubs »

Hi All,

I changed the server in one of my action buttons in excel, it is a button used to navigate to another application in TM1.

It has match title elements, rebuild worksheet & replace current workbook selected but none of these functions work anymore, only the navigation works.

I get a TM1 error message box pop up but it doesn't contain a message at all making it very hard to work out what is going on.

One thing I would mention is that I am using a single server reference as the server argument in my SubNM formulas on both my source sheet and destination sheet.

Any Ideas?

Cheers
User avatar
rkaif
Community Contributor
Posts: 328
Joined: Fri Sep 05, 2008 6:58 pm
OLAP Product: IBM Cognos TM1
Version: 9.1 or later
Excel Version: 2003 or later

Re: Action Button Functions Stopped Worked

Post by rkaif »

Have you changed the value of CUBE: in your spreadsheet and have changed the name of TM1 server? (by default it is cell B1)

Also have you tried recreating a new Action Button?
Cheers!
Rizwan Kaif
Post Reply