Excel workbook crashes TM1

[Martin Ryan]

What's the email address of Cognos support in the UK?

If anyone's got any ideas before I raise it with them: I've got a workbook that kills Excel when the TM1 add-in is loaded. Don't even have to be connected to TM1, just the add-in loaded. TM1 add in is 8.4.2. Excel is 2003 SP3. Nothing particularly exciting in the workbook, just a bunch of DBRW formulae and a few graphs.

As soon as I open the workbook (or open the add-in if I open the workbook first) Excel unceremoniously crashes. There are macros, but it dies even if they're disabled on load.

Cheers,
Martin

[Alan Kirk]

What's the email address of Cognos support in the UK?

If anyone's got any ideas before I raise it with them: I've got a workbook that kills Excel when the TM1 add-in is loaded. Don't even have to be connected to TM1, just the add-in loaded. TM1 add in is 8.4.2. Excel is 2003 SP3. Nothing particularly exciting in the workbook, just a bunch of DBRW formulae and a few graphs.

As soon as I open the workbook (or open the add-in if I open the workbook first) Excel unceremoniously crashes. There are macros, but it dies even if they're disabled on load.

This sounds vaguely familiar; I can't remember if we had EXACTLY the same symptoms (I'll have to see whether I can dig out the relevant correspondence when I get in to the office; it was 3 or 4 years ago IIRC), but we did have a workbook which for some seemingly inexplicable reason kept crashing Excel with TM1 loaded, but only with TM1 loaded.

It turned out that it had somehow managed to grow an inexplicable number of hidden shape objects within the workbook and somehow, don't ask me how, this was causing the Excel session to crash when the TM1 add-in was loaded.

I'd suggest that you load the workbook without TM1 and run something like this:

Code: Select all

Sub ShapesCount()

Dim wks As Excel.Worksheet

For Each wks In ThisWorkbook.Worksheets

    Debug.Print wks.Name & vbTab & wks.Shapes.Count
    
Next

Set wks = Nothing

End Sub

If you get some ridiculous 5 figure value on one of the sheets, odds are that's what's causing it and it's time for a slash & burn operation on those shapes. (Which you'll also have to do by code.)

Obscure and it may not even be the problem, but worth a shot.

[Martin Ryan]

IT discovered that the workbook was corrupted. I didn't ask for the details. The user has created a new one instead, so all's well that end's well.

Martin

[jim wood]

Everybody points the finger at TM1 because they have never had it before and it "seems" to crash excel more. What the average user never considers is that excel probably has more known bugs than any other software out there.

[Eric]

A Microsoft product with BUGS! BLASPHEMY! They have never released a product with over a million know bugs... ohh wait........

[Malcolm MacDonnell]

A bit late on this thread, but I would have looked to see if someone had saved the workbook with automatic calculation.

In my experience 90% of the time a workbook with TM1 formulae crashes that's the cause.

[Martin Ryan]

A bit late on this thread, but I would have looked to see if someone had saved the workbook with automatic calculation.

In my experience 90% of the time a workbook with TM1 formulae crashes that's the cause.

Yeah, I did check that, and also that the user could open the workbook if the TM1 add-in wasn't opened. Manual calculation made no difference and Excel only crashed when the add-in was present.

What was weird was that it stopped doing in the afternoon. Possibly because I tried doing it with Perspectives 9.1 then went back to 8.4. Possibly a switch got fixed by opening 9.1.

Martin

[Alan Kirk]

Everybody points the finger at TM1 because they have never had it before and it "seems" to crash excel more. What the average user never considers is that excel probably has more known bugs than any other software out there.

I'm guessing that you're not a regular user of Word then, Jim... 8^>

[jim wood]

Last time I looked most users don't use word as a TM1 front end. I do use it but nobody complains to me about it.

[Alan Kirk]

Last time I looked most users don't use word as a TM1 front end. I do use it but nobody complains to me about it.

For the sake of your sanity then, never, ever use an outline list that runs for more than 3 items in total. Actually 2 would be better. 1 is reasonably safe. On a good day.

[jim wood]

Web, now there is an up to date technology, one I can't use. My lovely IT department won't install the .net service pack required to run web as it is not part of the standard server build. To get it installed I will have to put together a benefits case etc... am I really that bothered??? No.