Excel 64-bit crashes in vbe7.dll when saving files with macros and CompileOnDemand=1 and ForceVBALoadFromSource=0

We keep having this issue:

Problem signature:

  Problem Event Name:                        APPCRASH

  Application Name:                             EXCEL.EXE

  Application Version:                           16.0.8431.2215

  Application Timestamp:                     5a745cd2

  Fault Module Name:                          VBE7.DLL

  Fault Module Version:                       0.0.0.0

  Fault Module Timestamp:                 59bae6d1

  Exception Code:                                  c0000005

  Exception Offset:                                00000000000f5b82

  OS Version:                                          6.1.7601.2.1.0.256.48

  Locale ID:                                             1033

Files containing macros and that linked to other worksheets crashed Excel in vbe7.dll.

We were able to fix the issue by following these MS articles:

https://support.microsoft.com/en-us/help/3085435/august-8-2017-update-for-excel-2016-kb3085435

https://blogs.technet.microsoft.com/the_microsoft_excel_support_team_blog/2012/09/07/excel-crashes-in-vbe7-dll-running-or-enabling-macro/

The following registry changes were needed:

~~~~~~

HKEY_CURRENT_USER\Software\Microsoft\VBA\7.0\Common

Type:  DWORD

Name:  CompileOnDemand

Value:  0

~~~~~~

• Locate and then select the following registry subkey: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options\

On the Edit menu, point to New, and then click DWORD Value.

Type ForceVBALoadFromSource, and then press Enter.

In the Details pane, right-click ForceVBALoadFromSource, and then click Modify.

In the Value data box, type 1, and then click OK.

You can perform the same changes by running these 3 commands:

Reg.exe add "HKCU\Software\Microsoft\Office\16.0\Excel\Options" /v "ForceVBALoadFromSource" /t REG_DWORD /d "1" /f

Reg.exe add "HKCU\Software\Microsoft\VBA\7.0\Common" /v "CompileOnDemand" /t REG_DWORD /d "0" /f

Reg.exe add "HKCU\Software\Microsoft\VBA\7.1\Common" /v "CompileOnDemand" /t REG_DWORD /d "0" /f

I am wondering if anyone else has this issue. If we remove these 2 registry settings, we start getting these crashes again. Any idea why Excel would crash without these 2 registry settings? In my understanding Excel should be catching exceptions and errors and should never outright crash. Why would these 2 settings prevent the crashes?