Hi,
One of my users has created an input template in excel which is a little busy but nothing TM1 can't handle.
This template has 3 tab, If you do a shift F9 then the recalc of the tab you are currently on works fine.
Do a full F9 or hit the recalc button of all 3 tab and excel dies ?
I have been having some issues with the Tm1pRibbonx.xlam on some machines and have found that if I change the name of this and use TM1 as an addin its seems to work better.
getting back to my problem, If I have the tm1Ribbon active and I hit F9 on this template then excel crashes.
If I change the name of the TM1pRibbonX and use TM1 as a addin and hit F9 or recalc then I get the following.
Microsoft Visual Basic
Runtime error '-2147467259 (80004005)':
Method 'PasteFace' of object' _CommandBarButton' Failed.
Just as a foot note if the template is accessed via Tm1web (As I have published it to see if that made a difference) then F9 and recalc work fine so certainly a problem with excel.
Does anyone have any ideas ?
thanks in advance
Method 'PasteFace' of object
- LeeTaylor1979
- Posts: 63
- Joined: Mon Aug 25, 2008 12:53 pm
- OLAP Product: IBM Cognos TM1
- Version: 10.2.2
- Excel Version: 2010
-
- MVP
- Posts: 229
- Joined: Fri Mar 11, 2011 2:18 pm
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 2003 2007
Re: Method 'PasteFace' of object
What about the IBM Technote 1362037 ?LeeTaylor1979 wrote:
Microsoft Visual Basic
Runtime error '-2147467259 (80004005)':
Method 'PasteFace' of object' _CommandBarButton' Failed.
Could that be your issue ?
https://www-304.ibm.com/support/docview ... wg21362037
TM1 Perspectives/Windows 2003 Terminal Services - PasteFace Error (282799)