Hi colleagues,
I have installed FP2 for 10.2 and Perspectives returns an error ("Run Time Error '13'") whenever I execute TM1RECALC function (tm1recalc1 and tm1refresh work fine)
We are using MS Excel 2010 SP2, 32bit
Has anybody faced similar problem with 10.2 or previous version?
Thanks a lot for help!
mar
TM1 Perspectives 10.2.2 FP2 'Run Time Error '13'
-
- Posts: 3
- Joined: Sun Nov 16, 2014 10:49 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
- Location: Australia
-
- MVP
- Posts: 3704
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: TM1 Perspectives 10.2.2 FP2 'Run Time Error '13'
Hi Mariusz
I would guess this might have something to do with worksheet or workbook protection. Are any sheets protected? Do you get the error if you either unprotect the sheet or set the protect pwd to blank before calling TM1RECALC ?
I would guess this might have something to do with worksheet or workbook protection. Are any sheets protected? Do you get the error if you either unprotect the sheet or set the protect pwd to blank before calling TM1RECALC ?
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Posts: 3
- Joined: Sun Nov 16, 2014 10:49 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
- Location: Australia
Re: TM1 Perspectives 10.2.2 FP2 'Run Time Error '13'
Hi lotsaram,
We have all the sheets protected with blank pwd, but even if I unprotect the problem remains. I experienced the problem while opening one of existing templates but then realized that I get the same problem with an empty sheet after pressing F9.
We have all the sheets protected with blank pwd, but even if I unprotect the problem remains. I experienced the problem while opening one of existing templates but then realized that I get the same problem with an empty sheet after pressing F9.
-
- Posts: 1
- Joined: Wed Dec 16, 2015 6:18 pm
- OLAP Product: IBM Cognos TM1
- Version: 10.2.2
- Excel Version: 2013
Re: TM1 Perspectives 10.2.2 FP2 'Run Time Error '13'
Hi - Did you get this issue resolved? I'm experiencing similar behavior.
-
- Posts: 3
- Joined: Sun Nov 16, 2014 10:49 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
- Location: Australia
Re: TM1 Perspectives 10.2.2 FP2 'Run Time Error '13'
Hi,
Apparently this should be resolved in 10.2.2 FP4, although haven't tried it myself
https://www-304.ibm.com/support/entdocv ... SS9RXT-_-E
Apparently this should be resolved in 10.2.2 FP4, although haven't tried it myself
https://www-304.ibm.com/support/entdocv ... SS9RXT-_-E