TM1 Action Buttons and Excel Crashing

[blaira]

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]

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

[kpk]

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

[blaira]

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]

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

[blaira]

No I do not get this message

[asutcliffe]

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]

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