TM1 Forum

When we open up an Excel workbook that has several worksheets and graphs(inherited from elsewhere), it distorts the "Tm1 ribbon" and gives a VB error.
It then won't allow one to write comments into a normal DBRW cell. It deletes the DBRW formula.
I don't see any macros on the workbook.

After much reading on the forum, I discovered similiar errors (on ver 95.2, we are on 10.1).
I have disable the tm1pRibbonX.xlam on my machine and if I connect using the 'Network', 'Connect' method and NOT server Explorer - it then works.
I have browsed the 10.1.1 fixes and can't see anythig similiar.
The error occurs on Excel 2007 and Excel 2010 machines.

One Excel 2010 machine doesn't work even after disabling the tm1pRibbonX.xlam

Any ideas or information would be welcome.

Not sure if related or not, but I know we used to have a similar problem when the charts in Excel where chart sheets (as opposed to a chart object in an excel worksheets). TM1 really doesn't like that, we had to convert all the Excel tabs that were Chart tabs into worksheet tabs (easy way to do this is to right-click the chart and move it as an object to a new worksheet).

That works!! Thank you.
We moved the chart tabs to normal sheet tabs and it works fine now.