TM1 Forum

We have TM1 9.5.2 installed and recently upgraded to Excel 2010 - and did not re-install TM1. My understanding is that we should not have to re-install TM1, however, I am hearing behavior such that in Perspectives, a slice will produce a worksheet with 95k rows - but if I do the same thing in Web, the slice truncates to 65,000 some rows.

I have not found a requirement that states we must reinstall TM1 if we upgrade to Excel 2010 - does anyone have any thoughts?

Thank you!!

I can't see why you would need to re install TM1 if upgrading MS Office.

I also can't see why you would ever need to export a slice of 65K or 95K rows from TM1 Web for that matter ! If people are doing that then something is wrong and some training is in order.

That rings a bell from a very old post, but I can't find it at the moment. There is a variable held in TM1 that defines the maximum number of rows currently available in Excel. I think the only way to update that variable is to re-install TM1 on top of the new Excel.

But along the lines of lotsaram's comment, this is only really necessary if you're doing enormous reports, which should generally be discouraged.

Martin

Martin Ryan wrote:That rings a bell from a very old post, but I can't find it at the moment. There is a variable held in TM1 that defines the maximum number of rows currently available in Excel. I think the only way to update that variable is to re-install TM1 on top of the new Excel.

That would be interesting to me if it existed. We have hit the column limit for a legitimate reason but have been limited by excel. The way it had been explained to me is the Web defaulted to the lowest value in the minimum requirements. Basically since web cannot tell what the client software was it defaulted to the Excel 2003 settings since it was the minimum requirement. This was a while ago from a conversation with support. I might try the re install method on a test server to see what comes out of it.