TM1 Action Buttons and Excel Crashing

Post Reply
blaira
Posts: 3
Joined: Wed Mar 10, 2010 8:51 pm
OLAP Product: TM1
Version: V9.1 SP4
Excel Version: 2003

TM1 Action Buttons and Excel Crashing

Post by blaira » Wed Mar 10, 2010 9:38 pm

Has anyone had issues with TM1 Action buttons and Excel crashing.

We have a couple of excel spreadsheets that have TM1 action buttons that crash when you close them.

We are running TM1 V9.1 SP4

Wim Gielis
MVP
Posts: 1976
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.6
Excel Version: 2016 - Office 365
Location: Brussels, Belgium
Contact:

Re: TM1 Action Buttons and Excel Crashing

Post by Wim Gielis » Thu Mar 11, 2010 9:41 am

Hello Blaira

Can you expand a little bit more on this?

So the file crashes when you try to close the file?
Does it crash when you have exactly the same file without the action button?
What is the purpose of the action button?
Does the crash occur if you did not use the button during the time the file was opened? (say, simply opening and closing the file)
What else is there in the spreadsheet? Did you try to remove a number of sheets / rows / columns / ... so to reduce the complexity and size of the file?
Is there VBA-code written for the file?
And so on.

Wim
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 108 TM1 articles and a lot of custom code
Newest blog article: Access to cube cells in TM1

kpk
MVP
Posts: 214
Joined: Tue Nov 11, 2008 11:57 pm
OLAP Product: TM1, CX
Version: TM1 7x 8x 9x 10x CX 9.5 10.1
Excel Version: XP 2003 2007 2010
Location: Hungary

Re: TM1 Action Buttons and Excel Crashing

Post by kpk » Thu Mar 11, 2010 10:39 am

Hello,

What is the Excel version do you use?
Is the crashing file developed in the same Excel version?
If Excel 2007 then do you save it as xlsx or xls?

Do you open it from a file server or from an application folder or from the TM1Web?
If TM1web then what is the version of Excel on the server?
If TM1Web then what is the version of your browser? Is it IE?

Regards,
Peter
Best Regards,
Peter

blaira
Posts: 3
Joined: Wed Mar 10, 2010 8:51 pm
OLAP Product: TM1
Version: V9.1 SP4
Excel Version: 2003

Re: TM1 Action Buttons and Excel Crashing

Post by blaira » Thu Mar 11, 2010 5:17 pm

The timing of when the crash occurs appears to be random and not based on a specific action (Closing is the most common action that produces the crashing)

Removing the button resolves the issue.

The action button was used to open another spreadsheet and pass cube parameters across to the other spreadsheet.

The spreadsheet does not have much else in it other than some DBRW's.

All the other VBA was removed from the spreadsheet.

We are using Excel 2003 SP3.

When we open the file in Excel 2007 it does not crash.

The problem is only a few of us have Excel 2007 and we need it to work in Excel 2003.

We are under the impression that it is a Excel Memory Leakage Issue.

laenen
Posts: 47
Joined: Tue Mar 09, 2010 6:40 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2003

Re: TM1 Action Buttons and Excel Crashing

Post by laenen » Thu Mar 11, 2010 5:58 pm

Do you notice if you get a "System Busy/Retry" dialog message prior to the crash?

blaira
Posts: 3
Joined: Wed Mar 10, 2010 8:51 pm
OLAP Product: TM1
Version: V9.1 SP4
Excel Version: 2003

Re: TM1 Action Buttons and Excel Crashing

Post by blaira » Thu Mar 11, 2010 9:09 pm

No I do not get this message

asutcliffe
Regular Participant
Posts: 162
Joined: Tue May 04, 2010 10:49 am
OLAP Product: Cognos TM1
Version: 9.4.1 - 10.1
Excel Version: 2003 and 2007

Re: TM1 Action Buttons and Excel Crashing

Post by asutcliffe » Tue May 18, 2010 8:25 am

I too am having problems with action buttons in workbooks not responding or causing crashes. I am on TM1 9.5 with Excel 2003 SP3 and just opening the spreadsheets directly not via TM1 web. The spreadsheets I'm having problems with were built in Excel 2007 though - is this likely to be the problem? I'm hoping to avoid a complete rebuild if possible!

CaptKirk
Posts: 4
Joined: Thu Jan 31, 2019 12:15 am
OLAP Product: TM1
Version: 10.2.2 FP7 IF 12
Excel Version: Excel 2016

Re: TM1 Action Buttons and Excel Crashing

Post by CaptKirk » Sun Mar 17, 2019 2:46 am

Hi
Couple of things I have noticed.
We had an action button as a Background Image - see attachment

1. Excel didn't crash if user had Perspectives
2. Changing this to a normal action button stopped Excel crashing for all users

BrianK
Attachments
Capture.JPG
Capture.JPG (48.89 KiB) Viewed 377 times

Post Reply