TM1 Perspectives 10.2.2 FP2 'Run Time Error '13'

Post Reply
Mariusz Pe
Posts: 3
Joined: Sun Nov 16, 2014 10:49 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010
Location: Australia

TM1 Perspectives 10.2.2 FP2 'Run Time Error '13'

Post by Mariusz Pe »

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
lotsaram
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'

Post by lotsaram »

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 ?
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Mariusz Pe
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'

Post by Mariusz Pe »

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.
TI_Sam
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'

Post by TI_Sam »

Hi - Did you get this issue resolved? I'm experiencing similar behavior.
Mariusz Pe
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'

Post by Mariusz Pe »

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