Page 1 of 1
Excel workbook crashes TM1
Posted: Wed Sep 17, 2008 10:13 am
by 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
Re: Excel workbook crashes TM1
Posted: Wed Sep 17, 2008 6:30 pm
by Alan Kirk
Martin Ryan wrote: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.
Re: Excel workbook crashes TM1
Posted: Thu Sep 18, 2008 8:54 am
by 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
Re: Excel workbook crashes TM1
Posted: Thu Sep 18, 2008 11:23 am
by 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.
Re: Excel workbook crashes TM1
Posted: Thu Sep 18, 2008 12:06 pm
by Eric
A Microsoft product with BUGS!
BLASPHEMY! They have never released a product with over a million know bugs... ohh wait........
Re: Excel workbook crashes TM1
Posted: Thu Sep 18, 2008 12:44 pm
by 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.
Re: Excel workbook crashes TM1
Posted: Thu Sep 18, 2008 1:08 pm
by Martin Ryan
Malcolm MacDonnell wrote: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
Re: Excel workbook crashes TM1
Posted: Thu Sep 18, 2008 6:27 pm
by Alan Kirk
jim wood wrote: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^>
Re: Excel workbook crashes TM1
Posted: Fri Sep 19, 2008 7:05 am
by 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.
Re: Excel workbook crashes TM1
Posted: Fri Sep 19, 2008 10:22 am
by Alan Kirk
jim wood wrote: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.
Re: Excel workbook crashes TM1
Posted: Fri Sep 19, 2008 1:05 pm
by 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.