Error in macro Excel_TM1ServerConnect SCODE=8000ffff

[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

[Alan Kirk]

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.)

[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.