Hi all,
I create a simple spreadsheet with an action button linked to a process.
This process has 3 parameters in input (please see the attached image)
After inserting the button I tested the functionalities immediately and they worked well.
So, I saved the spreadsheet.
After a day I opened the same file and I noticed that action button parameters was in an incorrect form (see the attached image please) and the action button doesn't work.
Does anybody can tell me the reason of this issue and how can i solve it, please?
Regards
Action Button issue
-
- Posts: 54
- Joined: Thu Oct 18, 2012 5:08 pm
- OLAP Product: Cognos TM1
- Version: 10.1.1
- Excel Version: 2010
- Location: Italy
-
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Action Button issue
This is a known issue/bug and I can't off the top of my head remember whether it was the version of excel you were using combined with TM1 version etc.
But to avoid stuff like this I tend to always save the books in Excel 97-2003 xls format as opposed to xlsx, try that and see if you have the same issue?
Edit - From what I remember it was an issue of using a version of Excel that wasn't fully compatible with your version of TM1 e.g. TM1 9.5.1 with Excel 2010... but I noticed that you are using TM1 10 so I might be thinking of a different issue altogether
But to avoid stuff like this I tend to always save the books in Excel 97-2003 xls format as opposed to xlsx, try that and see if you have the same issue?
Edit - From what I remember it was an issue of using a version of Excel that wasn't fully compatible with your version of TM1 e.g. TM1 9.5.1 with Excel 2010... but I noticed that you are using TM1 10 so I might be thinking of a different issue altogether
Declan Rodger
-
- Posts: 54
- Joined: Thu Oct 18, 2012 5:08 pm
- OLAP Product: Cognos TM1
- Version: 10.1.1
- Excel Version: 2010
- Location: Italy
Re: Action Button issue
Great!
I saved all my spreadsheet in XLS formato and now all work well!
Many thanks!!!
I saved all my spreadsheet in XLS formato and now all work well!
Many thanks!!!