Page 1 of 1

Error in macro Excel_TM1ServerConnect SCODE=8000ffff

Posted: Wed Jun 29, 2011 4:58 am
by northyj
I'm getting this message when I log in to TM1 and no idea why or where I should start looking to fix this. If anyone has any ideas I'd appreciate it. Thanks

Re: Error in macro Excel_TM1ServerConnect SCODE=8000ffff

Posted: Wed Jun 29, 2011 5:04 am
by Alan Kirk
northyj wrote:I'm getting this message when I log in to TM1 and no idea why or where I should start looking to fix this. If anyone has any ideas I'd appreciate it. Thanks
Hah! Funny you should mention that, it's exactly the same error that comes up when there's been an unhandled error in your Visual Basic Editor, causing the add-in to lose some of its object initialisations and therefore spit its dummy when it tries to set the oh-so-useful little light on the TM1 Servers toolbar. It should actually go away when you restart Excel, unless you have something in your Personal workbook or some other workbook that you load at start-up which always causes an unhandled VBA error.

Alternatively, you can get rid of that waste-of-space toolbar by following the instructions in the
post that I made this morning, which should prevent it from happening.

(Indeed, it was the fact that I got that very error one too many times that prompted me to make that post and send my TM1 Servers toolbar to siberia.)

Re: Error in macro Excel_TM1ServerConnect SCODE=8000ffff

Posted: Mon Jul 04, 2011 11:56 pm
by northyj
Thanks Alan. I had checked my personal workbook and VBA within it and found nothing to suggest a problem but then TM1 can be a funny beast at times.

It seems the old trick of ctrl +alt +delete worked on this occassion which now makes me feel a fool for not trying the standard help desk response before. Thanks for taking the time to reply, much appreciated.