9.4.1 FP2 - Excel Crashes when refreshing spreadsheets
-
- Posts: 17
- Joined: Thu Aug 07, 2008 11:24 pm
- OLAP Product: TM1
- Version: TM1 v 10.1.1
- Excel Version: 2003
9.4.1 FP2 - Excel Crashes when refreshing spreadsheets
Hi All
We recently upgraded from Ver 9.1 SP3 to ver 9.4.1 FP2. We had to roll this back ,as it was discovered that when users refreshed their spreadsheets, more than once , it would cause Excel to crash.We have Office 2003 installed.
The following error message was displayed
AppName: excel.exe AppVer: 11.0.8231.0 AppStamp:48934d57
ModName: tm1api.dll ModVer: 9.4.10200.61478 ModStamp:4a3f136e
fDebug: 0 Offset: 00016a89
We refreshed the same spreadsheets with FP1 , and did not encounter these issues.
This has been logged with IBM, and we are waiting for their response.
Has anyone else experienced this?
Thanks in advance for your input
Armand
We recently upgraded from Ver 9.1 SP3 to ver 9.4.1 FP2. We had to roll this back ,as it was discovered that when users refreshed their spreadsheets, more than once , it would cause Excel to crash.We have Office 2003 installed.
The following error message was displayed
AppName: excel.exe AppVer: 11.0.8231.0 AppStamp:48934d57
ModName: tm1api.dll ModVer: 9.4.10200.61478 ModStamp:4a3f136e
fDebug: 0 Offset: 00016a89
We refreshed the same spreadsheets with FP1 , and did not encounter these issues.
This has been logged with IBM, and we are waiting for their response.
Has anyone else experienced this?
Thanks in advance for your input
Armand
-
- Posts: 1
- Joined: Tue Aug 11, 2009 7:07 pm
- OLAP Product: TM1
- Version: 9.4.1
- Excel Version: 2007
Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets
We are receiving a similar issue but have no resolution. If you get a response, please share.
Regards,
Regards,
- mattgoff
- MVP
- Posts: 516
- Joined: Fri May 16, 2008 1:37 pm
- OLAP Product: TM1
- Version: 10.2.2.6
- Excel Version: O365
- Location: Florida, USA
Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets
Every time I have ever had this issue with a user it has been resolved by going to http://office.microsoft.com --> Downloads --> Check for free updates (or Start --> Microsoft Update if you've already done this before) and installing every one of the Excel patches. YMMV.
Matt
Matt
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
- Steve Rowe
- Site Admin
- Posts: 2423
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets
There is clearly an issue with the client of 9.4.1 FP2 see also this link
IBM state to use the client for 9.4.1 FP1 and wait until FP3 for a fix for the issue on the FP2 client.
Can I remind users of the forum to try and update this section of the forum with known issues. Some people could have been saved pain if this issue had been posted when it was first noted.
Cheers!
IBM state to use the client for 9.4.1 FP1 and wait until FP3 for a fix for the issue on the FP2 client.
Can I remind users of the forum to try and update this section of the forum with known issues. Some people could have been saved pain if this issue had been posted when it was first noted.
Cheers!
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- Posts: 43
- Joined: Thu Sep 10, 2009 6:36 am
- OLAP Product: TM1
- Version: 9.0 and above
- Excel Version: 2003
Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets
Hi,
IBM released a hot fix HF16 which fixes this bug and few more including the popup error "Error in macro Excel_TM1ServerConnect SCODE = 800010105. The server threw an exception".
IBM released a hot fix HF16 which fixes this bug and few more including the popup error "Error in macro Excel_TM1ServerConnect SCODE = 800010105. The server threw an exception".
-
- Posts: 17
- Joined: Thu Aug 07, 2008 11:24 pm
- OLAP Product: TM1
- Version: TM1 v 10.1.1
- Excel Version: 2003
Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets
Hi
We are contemplating installing this hotfix.
Has anyone had any experience with this Hot Fix?
Cheers
Armand
We are contemplating installing this hotfix.
Has anyone had any experience with this Hot Fix?
Cheers
Armand
- Steve Vincent
- Site Admin
- Posts: 1054
- Joined: Mon May 12, 2008 8:33 am
- OLAP Product: TM1
- Version: 10.2.2 FP1
- Excel Version: 2010
- Location: UK
Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets
probably not, seeing as even if you are signed up to receive notification of new software from IBM they don't tell you it even exists ![Sad :(](./images/smilies/icon_e_sad.gif)
![Sad :(](./images/smilies/icon_e_sad.gif)
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets
Hotfixes aren't announced as they are basically code patches that have barely been tested. One either needs to hear about them (like here) or have an open support ticket that references the bug/issue (good luck with that).
-
- Posts: 43
- Joined: Thu Sep 10, 2009 6:36 am
- OLAP Product: TM1
- Version: 9.0 and above
- Excel Version: 2003
Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets
Yes.. This is like an emergency fix we got when we reported this problem to IBM... We do not face this multiple recalculate issue anymore...
-
- Posts: 74
- Joined: Mon May 12, 2008 12:25 pm
- OLAP Product: TM1
- Version: PA 2.0.6 Local
- Excel Version: Excel 2016
Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets
HF16 on our Vista / Office 2007 test laptop results in Excel crashing all the time while running our load tests.
We were given the HotFix to try and get our performance back (load models were taking 5+ times longer on Vista / Office 2007 / 9.4.1 than XP / Office 2003 / 9.1.3) and also to see if it addressed the "stutter" question I'd asked about before.
Tony
We were given the HotFix to try and get our performance back (load models were taking 5+ times longer on Vista / Office 2007 / 9.4.1 than XP / Office 2003 / 9.1.3) and also to see if it addressed the "stutter" question I'd asked about before.
Tony
-
- Posts: 38
- Joined: Wed Mar 25, 2009 7:35 am
- OLAP Product: TM1
- Version: 9.4.1
- Excel Version: 2003
Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets
I've just come across the same error messageSandhya Kumar wrote:Hi,
IBM released a hot fix HF16 which fixes this bug and few more including the popup error "Error in macro Excel_TM1ServerConnect SCODE = 800010105. The server threw an exception".
Thanks for your tip.