TM1 Forum

Has any had the above error on a workbook in TM1? If you are not connected to TM1 the workbook opens fine but if you do connect to TM1 it all crashes and Excel recovers the work. Any ideas how to resolve the issue?

We are using TM1 9.4.1 FP3 and Excel 2003.

Unfortunately this is a common error, and is due to Excel getting out of step with TM1.

A possible suggestion would be

In Excel Add Ins, untick the TM1 Add In

Make a copy of the Excel Shortcut and call it TM1

Edit the shortcut to add the path to the TM1P.XLA after the EXCEL.EXE part with a space in between

This will start Excel and then open the XLA just like it was a command line argument of a spreadsheet to be opened.

That may get around your problem, however, the issue is really one in 9.4

Regards


Paul Simon

Hi thanks for the above suggestion but it didnt fix the problem.

Hi All,
been a while but now back on the TM1 wagon.

I have experienced this problem a number of times when accessing TM1 via explorer. After clicking OK to the error messages TM1 tends to behave as normal.

I am now working on a project where the login is managed via VBA. This is causing problems as we need to be able to handle the error when it occurs.
Ideallly I would like to fix this problem on the profile rather than code for it.

Have tried the following with no success.
1. Cleared all temp files
2. Deleted the Applix folder whetre the ini files are held in the Documents & Settings\ folders under the user profile
3. Re-installed Excel (which used to fix this type of issue)
4. reboots after each of the above actions.

One thing we have ascertained is that this is profile related.
If another user logs into the same PC, the problem does not exist (until a situation occurs causing the same error)

Anyone got any ideas?
This error is occuring on TM1 9.4 FP3, Excel 2003, Win XP

After much perseverance I found a solution that works.

Under c:\documents and Settings\user name xxx\application data \Microsoft\Excel there is a file called Excel11.xlb which holds toolbar customisation data

By deleting this all error messages have disappeared and TM1 is back to normal.

This file gets recreated when Excel starts again.

To summarise steps I followed were

1. Exit Excel
2. Delete Excel11.xlb file
3. Restart Excel (without launching TM1 addin)
4. Close Excel and then start Excel with TM1 addin.

Hope this helps