Access to TM1 Excel Macros

Post Reply
nhavis
Posts: 62
Joined: Mon Jan 05, 2009 12:47 am

Access to TM1 Excel Macros

Post by nhavis »

How can I gan access to the TM1 Excel macros?

For example access to the following macro:
Attachments
error.JPG
error.JPG (7.46 KiB) Viewed 4576 times
hsulakhe
Posts: 6
Joined: Mon Feb 09, 2009 6:27 am
Version: 9.4
Excel Version: 2003

Re: Access to TM1 Excel Macros

Post by hsulakhe »

Even one of my user is facing the above issue. Do you or anyone have suggestion on this, i was planning to reinstall the TM1 perspective on the user machine. Any other alternative available.
User avatar
Martin Ryan
Site Admin
Posts: 1989
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Access to TM1 Excel Macros

Post by Martin Ryan »

Try getting the user to close TM1 and Excel. If that doesn't work then try restarting the client's PC. That will usually make it go away.

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
nhavis
Posts: 62
Joined: Mon Jan 05, 2009 12:47 am

Re: Access to TM1 Excel Macros

Post by nhavis »

Is there a way to access these macro's, though?
User avatar
Martin Ryan
Site Admin
Posts: 1989
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Access to TM1 Excel Macros

Post by Martin Ryan »

No, not unless you know Cognos' password. tm1p.xla is password protected.

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
User avatar
Steve Vincent
Site Admin
Posts: 1054
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Re: Access to TM1 Excel Macros

Post by Steve Vincent »

Yep, we get it here occasionally too, a restart of the TM1 client / Excel usually fixes it.
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Post Reply