After the latest update, plotting regression residuals using the Analysis ToolPack add-ins causes 64-bit Excel 2013 (15.0.4667.1000 ) to crash and stop working.

On an older version of Excel 2013 (64 bit 15.0.4649.1000), I can use the Analysis ToolPack add-ins without a problem and plot the residuals.

Is this a known problem?

• Edited by rooneye Tuesday, November 25, 2014 9:03 PM

Yup same here

Hi,

In regarding of this issue, I need more information to do troubleshooting. Please upload the Event log and App crash dump file through OneDrive.

=====

App crash dump file

First enable app crash dump collection by copying following words into notepad, saving it as dump.reg and importing it:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Windows Error Reporting\localdumps\EXCEL.EXE]

"DumpFolder"=hex(2):63,00,3a,00,5c,00,63,00,72,00,61,00,73,00,68,00,64,00,75,\

  00,6d,00,70,00,73,00,00,00

"DumpCount"=dword:00000010

"DumpType"=dword:00000001

"CustomDumpFlags"=dword:00000000

Then, open Excel to repro the issue. If crash issue appeared, please find the crashdump file under c:\.

To further help you, please upload this file into OneDrive and shared the link here.

Also, you can try to analyze dump by yourself if you would like to

How to analyze app crash dump file:

http://blogs.technet.com/b/askperf/archive/2007/05/29/basic-debugging-of-an-application-crash.aspx

====

Please feel free let us know, if you have any update.

Regards,

George Zhao
TechNet Community Support

The crashdumps are available on OneDrive at: https://onedrive.live.com/redir?resid=BA18336B65C5562A!18756&authkey=!AN0hNG-EjZnQp8Q&ithint=folder%2cdmp

• Edited by rooneye Wednesday, November 26, 2014 5:25 PM

I have the exact same problem on my brand new surface pro3. grrr.........

Hi Sir,

Here is a quick note, I need some time to download/analyze the log.

===

update:

Microsoft (R) Windows Debugger Version 6.3.9600.16384 AMD64
Copyright (c) Microsoft Corporation. All rights reserved.


Loading Dump File [C:\Users\v-qinlu\Downloads\EXCEL.EXE.10152.dmp]
User Mini Dump File: Only registers, stack and portions of memory are available

WARNING: Whitespace at end of path element

************* Symbol Path validation summary **************
Response                         Time (ms)     Location
Deferred                                       srv*C:\symbols*http://msdl.microsoft.com/download/symbols
Symbol search path is: srv*C:\symbols*http://msdl.microsoft.com/download/symbols;C:\mysymbols*http://symweb

Executable search path is: 
Windows 8 Version 9879 MP (8 procs) Free x64
Product: WinNt, suite: SingleUserTS
Built by: 6.4.9879.0 (fbl_release.141103-1722)
Machine Name:
Debug session time: Thu Nov 27 01:00:26.000 2014 (UTC + 8:00)
System Uptime: not available
Process Uptime: 0 days 0:01:02.000
................................................................
................................................................
......................................
Loading unloaded module list
...............
This dump file has an exception of interest stored in it.
The stored exception information can be accessed via .ecxr.
(27a8.2424): Unknown exception - code c0000374 (first/second chance not available)
ntdll!NtWaitForMultipleObjects+0xa:
00007ff8`cf1e788a c3              ret
0:000> !analyze -v
*******************************************************************************
*                                                                             *
*                        Exception Analysis                                   *
*                                                                             *
*******************************************************************************

*** WARNING: Unable to verify timestamp for MSO.DLL
*** ERROR: Module load completed but symbols could not be loaded for MSO.DLL
*** WARNING: Unable to verify timestamp for OART.DLL
*** ERROR: Module load completed but symbols could not be loaded for OART.DLL
Unable to load image C:\Windows\assembly\NativeImages_v4.0.30319_64\mscorlib\f931888a37cf30087f7d9728aa5bd7c8\mscorlib.ni.dll, Win32 error 0n2
*** WARNING: Unable to verify timestamp for EXCEL.EXE
*** ERROR: Module load completed but symbols could not be loaded for EXCEL.EXE
Unable to load image C:\Program Files\Microsoft Office\Office15\Library\Analysis\ANALYS32.XLL, Win32 error 0n2
*** WARNING: Unable to verify timestamp for ANALYS32.XLL
*** ERROR: Module load completed but symbols could not be loaded for ANALYS32.XLL
*** WARNING: Unable to verify timestamp for VBE7.DLL
*** WARNING: Unable to verify timestamp for atidxx64.dll
*** ERROR: Module load completed but symbols could not be loaded for atidxx64.dll
*** The OS name list needs to be updated! Unknown Windows version: 6.4 ***

FAULTING_IP: 
ntdll!RtlReportCriticalFailure+8c
00007ff8`cf241634 eb00            jmp     ntdll!RtlReportCriticalFailure+0x8e (00007ff8`cf241636)

EXCEPTION_RECORD:  ffffffffffffffff -- (.exr 0xffffffffffffffff)
ExceptionAddress: 00007ff8cf241634 (ntdll!RtlReportCriticalFailure+0x000000000000008c)
   ExceptionCode: c0000374
  ExceptionFlags: 00000001
NumberParameters: 1
   Parameter[0]: 00007ff8cf29b330

CONTEXT:  0000000000000000 -- (.cxr 0x0;r)
rax=000000b448300000 rbx=0000000000000000 rcx=000000b448300000
rdx=0000000000000000 rsi=0000000000000000 rdi=0000000000000000
rip=00007ff8cf1e788a rsp=000000b439389e58 rbp=000000b43938ae70
 r8=0000000000001000  r9=0000000000000000 r10=0000000000000040
r11=0000000000000286 r12=0000000000000000 r13=000000b4482f0000
r14=ffffffffffffffff r15=0000000000000000
iopl=0         nv up ei pl nz na pe cy
cs=0033  ss=002b  ds=002b  es=002b  fs=0053  gs=002b             efl=00000203
ntdll!NtWaitForMultipleObjects+0xa:
00007ff8`cf1e788a c3              ret

DEFAULT_BUCKET_ID:  WRONG_SYMBOLS

PROCESS_NAME:  EXCEL.EXE

OVERLAPPED_MODULE: Address regions for 'MSVCR120_CLR0400' and 'MSOIDRes.DLL' overlap

ERROR_CODE: (NTSTATUS) 0xc0000374 - A heap has been corrupted.

EXCEPTION_CODE: (NTSTATUS) 0xc0000374 - A heap has been corrupted.

EXCEPTION_PARAMETER1:  00007ff8cf29b330

NTGLOBALFLAG:  0

APPLICATION_VERIFIER_FLAGS:  0

APP:  excel.exe

ANALYSIS_VERSION: 6.3.9600.16384 (debuggers(dbg).130821-1623) amd64fre

MANAGED_STACK: !dumpstack -EE
OS Thread Id: 0x2424 (0)
Current frame: 
Child-SP         RetAddr          Caller, Callee

PRIMARY_PROBLEM_CLASS:  WRONG_SYMBOLS

BUGCHECK_STR:  APPLICATION_FAULT_WRONG_SYMBOLS

LAST_CONTROL_TRANSFER:  from 00007ff8cf244cd2 to 00007ff8cf241634

STACK_TEXT:  
000000b4`3938b460 00007ff8`cf244cd2 : 000000b4`3938b728 00007ff8`cf29b330 000000b4`39410000 00000000`3fff64fe : ntdll!RtlReportCriticalFailure+0x8c
000000b4`3938b570 00007ff8`cf1e6dec : 000000b4`39410000 000000b4`39410000 00000000`00000000 00007ff8`b4661d11 : ntdll!RtlpHeapHandleError+0x12
000000b4`3938b5a0 00007ff8`cf202252 : 00007ff8`b4767b34 00000000`00000000 00000000`00000000 00000000`00000002 : ntdll!RtlpLogHeapFailure+0xa8
000000b4`3938b5d0 00007ff8`cced68cb : 000000b4`3938b6a0 00007ff8`b4767bb5 00000000`00000048 000000b4`3938b6c0 : ntdll!RtlFreeHeap+0x5bd62
000000b4`3938b670 00007ff8`ccf5aec0 : 000000b4`3938b6d0 00000000`00000048 000000b4`3938b8a0 000000b4`3938b8a0 : oleaut32!MemFree+0x43
000000b4`3938b6a0 00007ff8`b4767b34 : 000000b4`3938b8a0 000000b4`3938b8a0 000000b4`3938b700 000000b4`6c3c3040 : oleaut32!VariantInit+0x20
000000b4`3938b6e0 000000b4`3938b8a0 : 000000b4`3938b8a0 000000b4`3938b700 000000b4`6c3c3040 000000b4`3938b790 : MSO+0x107b34
000000b4`3938b6e8 000000b4`3938b8a0 : 000000b4`3938b700 000000b4`6c3c3040 000000b4`3938b790 00007ff8`a2757637 : 0x000000b4`3938b8a0
000000b4`3938b6f0 000000b4`3938b700 : 000000b4`6c3c3040 000000b4`3938b790 00007ff8`a2757637 00000000`00d59b5b : 0x000000b4`3938b8a0
000000b4`3938b6f8 000000b4`6c3c3040 : 000000b4`3938b790 00007ff8`a2757637 00000000`00d59b5b 000000b4`6c3c3040 : 0x000000b4`3938b700
000000b4`3938b700 000000b4`3938b790 : 00007ff8`a2757637 00000000`00d59b5b 000000b4`6c3c3040 000000b4`6c3c3040 : 0x000000b4`6c3c3040
000000b4`3938b708 00007ff8`a2757637 : 00000000`00d59b5b 000000b4`6c3c3040 000000b4`6c3c3040 00007ff8`a2761132 : 0x000000b4`3938b790
000000b4`3938b710 00000000`00d59b5b : 000000b4`6c3c3040 000000b4`6c3c3040 00007ff8`a2761132 00000001`00000000 : OART+0x247637
000000b4`3938b718 000000b4`6c3c3040 : 000000b4`6c3c3040 00007ff8`a2761132 00000001`00000000 00000001`00000000 : 0xd59b5b
000000b4`3938b720 000000b4`6c3c3040 : 00007ff8`a2761132 00000001`00000000 00000001`00000000 00000000`00000000 : 0x000000b4`6c3c3040
000000b4`3938b728 00007ff8`a2761132 : 00000001`00000000 00000001`00000000 00000000`00000000 00000000`00000000 : 0x000000b4`6c3c3040
000000b4`3938b730 00000001`00000000 : 00000001`00000000 00000000`00000000 00000000`00000000 00000001`00000000 : OART+0x251132
000000b4`3938b738 00000001`00000000 : 00000000`00000000 00000000`00000000 00000001`00000000 3f800000`00000000 : 0x00000001`00000000
000000b4`3938b740 00000000`00000000 : 00000000`00000000 00000001`00000000 3f800000`00000000 00000001`7fd59b5b : 0x00000001`00000000


STACK_COMMAND:  ~0s; .ecxr ; kb

FOLLOWUP_IP: 
MSO+107b34
00007ff8`b4767b34 ??              ???

SYMBOL_STACK_INDEX:  6

SYMBOL_NAME:  mso+107b34

FOLLOWUP_NAME:  MachineOwner

MODULE_NAME: MSO

IMAGE_NAME:  MSO.DLL

DEBUG_FLR_IMAGE_TIMESTAMP:  54477f6d

FAILURE_BUCKET_ID:  WRONG_SYMBOLS_c0000374_MSO.DLL!Unknown

BUCKET_ID:  APPLICATION_FAULT_WRONG_SYMBOLS_mso+107b34

ANALYSIS_SOURCE:  UM

FAILURE_ID_HASH_STRING:  um:wrong_symbols_c0000374_mso.dll!unknown

FAILURE_ID_HASH:  {eb7221c7-42e7-608d-f820-db9c6f32f3c8}

Followup: MachineOwner
---------

0:000> lmvm MSO
start             end                 module name
00007ff8`b4660000 00007ff8`b6981000   MSO      T (no symbols)           
    Loaded symbol image file: MSO.DLL
    Image path: C:\Program Files\Common Files\Microsoft Shared\OFFICE15\MSO.DLL
    Image name: MSO.DLL
    Timestamp:        Wed Oct 22 17:57:01 2014 (54477F6D)
    CheckSum:         02320022
    ImageSize:        02321000
    File version:     15.0.4667.1001
    Product version:  15.0.4667.0
    File flags:       0 (Mask 3F)
    File OS:          40004 NT Win32
    File type:        2.0 Dll
    File date:        00000000.00000000
    Translations:     0000.04b0 0000.04e4 0409.04b0 0409.04e4

This issue is due to the Faulting module name: mso.dll.

Please try the 2 method:

1. Renamed the MSO.DLL in

C:\Program Files\Microsoft Office 15\root\vfs\ProgramFilesCommonX86\Microsoft Shared\OFFICE15

The copied the MSO.DLL from 

C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE15

to 

C:\Program Files\Microsoft Office 15\root\vfs\ProgramFilesCommonX86\Microsoft Shared\OFFICE15

2. If we installed KB2880987, please try to remove it to test.

Hope it's helpful.

Regards,

George Zhao
TechNet Community Support

how do i upload dump file to one cloud?

I do not have a "C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE15" folder on this PC. I have OFFICE14 instead of OFFICE15. I swapped MSO.dll files as you suggested in step 1. I did not have the update installed on my PC as you indicated in step 2.

I retested running the regression in Excel and plotting the residuals and Excel still crashed.

I will attempt to test this on another PC as well.

i am unclear on the recommendation.  can you provide more guidance?

I re-attempted these steps on my Windows 8.1 Enterprise 64-bit PC running Excel 2013 64 bit 15.0.4667.1000. The directory "C:\Program Files\Microsoft Office 15\root\vfs\ProgramFilesCommonX86\Microsoft Shared\OFFICE15" in step 1 does not exist. The directory "C:\Program Files\Microsoft Office 15" does not exist on this PC so I was unable to hunt for and locate the MSO.DLL file referenced.

KB2880987 is not installed on this PC.

Anyone found a solution to this issue yet?

(I'm running Excel 64-bit also and don't have the directories or files referenced in the workaround)

I've had similar issues ONLY when using Office 2013. My Macro crashes at random. The only way I can get it to open is to save it to another computer and re open on my 2013. I calked Microsoft and listed on the forum. The response was my macro is corrupt.  There is nothing wrong with my macros. They work perfectly fine on my desktop which has Windows 7 Office 2010. IMHO there are done issues with 2013 although it has great features that 2010 does not offer

Hello Larbec,

Don't put any reliance on MS "support". I called them on a license issue for Office 365 and she had no clue what that was ... go figure ....

Although it might be a bug with some versions/updates, can you try running the failing macro on a similar computer, only with more RAM?

I tested again. My 64-bit version of Excel 2013 has been updated to 15.0.4675.1000. Plotting regression residuals using the Analysis ToolPack add-ins still causes Excel 2013 to crash, BUT it recovers and displays a Book1 (version 1).xlsxb [Recovered] file with the regression analysis and residual plots.

So progress in the right direction, but still broken.

Any progress or thoughts on this, Microsoft?

This problem no longer exists in Excel 2016 Preview (64-bit).

Good enough for me, I suppose.

Migrating users over tomorrow.

I am having the exact same issue. Everytime I run a Regression analysis and add any type of plots Excel crashes. Is there any fix?

Any reply from Microsoft, it is clear that is a know issue for all communities, is there any fix/patch coming soon?