This article describes update 4011597 for Microsoft Excel 2013 that was released on December 5, 2017. This update also applies to Office Home and Student 2013 RT. This update has a prerequisite.

Be aware that the update in the Microsoft Download Center applies to the Microsoft Installer (.msi)-based edition of Office 2013. It doesn't apply to the Office 2013 Click-to-Run editions, such as Microsoft Office 365 Home. (How to determine?)

Improvements and fixes

This update fixes the following issues:

  • The compiled stream of the VBA project in Excel is corrupted and causes Excel 2013 to crash. To work around this issue, install this update and then follow the steps in the Registry information section.

  • Assume that there's an IOfficeAntivirus scanner registered that includes Windows Defender as of Windows 10 Version 1709. In this situation, when you repair an Excel worksheet through the File Open dialog box, Excel 2013 may crash or receive an antivirus positive result incorrectly.

  • After you install the May 2, 2017, update for Excel 2013 (KB3191877), you may receive the following error message when you click the Enable Content button on the security-warning bar in Excel 2013:

    Compile Error: Automation error. Fatal error

This update also improves the translation of the message for cells error checking in the Dutch version of Excel 2013.

How to download and install the update

Microsoft Update

Use Microsoft Update to automatically download and install the update.

Microsoft Update Catalog

To get the stand-alone package for this update, go to the Microsoft Update Catalog website.

If you're not sure which platform (32-bit or 64-bit) you're running, see Am I running 32-bit or 64-bit Office? Additionally, see more information about how to download Microsoft support files.

Microsoft scanned this file for viruses by using the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to it.

Update information

Registry information

After you install this update, you can follow these steps to force a recompile of all VBA projects that are opened in Excel 2013.

Important
Follow the steps in this section carefully. Serious problems might occur if you modify the registry incorrectly. Before you modify it, back up the registry for restoration in case problems occur.

  1. Exit all Microsoft Office applications.

  2. Start Registry Editor:

    • In Windows 10, go to Start, enter regedit in the Search Windows box, and then select regedit.exe in the search results.

    • In Windows 7, click Start, type regedit in the Search programs and files text box, and then click regedit.exe in the search results.

    • In Windows 8 and Windows 8.1, move your mouse to the upper-right corner, click Search, type regedit in the search text box, and then click regedit.exe in the search results.

    Note To start Registry Editor, you have to log on by using a user account that has administrator permissions.

  3. Locate and then select the following registry subkey:

    HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Excel\Options

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

  5. Type ForceVBALoadFromSource, and then press Enter.

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

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

    Note Depends on the size of your VBA projects, you may experience performance issues when you use this option. Therefore, we recommend that you only use this option for security reason to mandate that all VBA solutions are recompiled.

  8. Exit Registry Editor.

Tip If you want to bypass the above manual steps, you can copy the following text to a file that has the .reg extension and then import it into the Registy:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Excel\Options]
"ForceVBALoadFromSource"=dword:00000001

Prerequisites

To apply this update, you must have Microsoft Office 2013 Service Pack 1 installed.

Restart information

You may have to restart the computer after you install this update.

More information

To determine whether your Office installation is Click-to-Run or MSI-based, follow these steps:

  1. Start an Office 2013 application, such as Microsoft Word 2013.

  2. On the File menu, select Account.

  3. For Office 2013 Click-to-Run installations, an Update Options item is displayed. For MSI-based installations, the Update Options item isn't displayed.

Office 2013 Click-to-Run installation

MSI-based Office 2013

The screenshot for Word Click To Run

The screenshot for Word MSI

How to uninstall this update

Windows 10

  1. Go to Start, enter View Installed Updates in the Search Windows box, and then press Enter.

  2. In the list of updates, locate and then select update KB4011597, and then select Uninstall.

Windows 8 and Windows 8.1

  1. Swipe in from the right edge of the screen, and then tap Search. If you're using a mouse, point to the lower-right corner of the screen, and then select Search.

  2. Enter windows update, select Windows Update, and then select Installed Updates.

  3. In the list of updates, locate and then select update KB4011597, and then select Uninstall.

Windows 7

  1. Go to Start, enter Run, and then select Run.

  2. Enter Appwiz.cpl, and then select OK.

  3. Select View installed updates.

  4. In the list of updates, locate and then select update KB4011597, and then select Uninstall.

References

Learn about the standard terminology that Microsoft uses to describe software updates.

The Office System TechCenter contains the latest administrative updates and strategic deployment resources for all versions of Office.

File information

x64

excel-x-none.msp file information

File identifier

File name

File version

File size

Date

Time

Excel.exe

Excel.exe

15.0.4989.1000

33,047,720

15-Nov-2017

11:11

Excel.man

Excel.exe.manifest

Not applicable

1,227

15-Nov-2017

11:11

Xl12cnv.exe

Excelcnv.exe

15.0.4989.1000

29,511,848

15-Nov-2017

11:11

Xl12cnvp.dll

Excelcnvpxy.dll

15.0.4454.1000

48,704

15-Nov-2017

11:11

Exptoows.xla.1033

Exptoows.xla

Not applicable

114,688

15-Nov-2017

11:11

Solver.xlam_1033

Solver.xlam

Not applicable

426,707

16-Nov-2017

11:14

Solver32.dll_1033

Solver32.dll

15.0.4454.1000

216,136

15-Nov-2017

11:10

Xlcall32.dll

Xlcall32.dll

15.0.4454.1000

10,856

15-Nov-2017

11:11

Xlicons.exe

Xlicons.exe

15.0.4553.1000

3,685,544

15-Nov-2017

11:10

Xlintl32.dll_1033

Xlintl32.dll

15.0.4703.1000

4,483,768

15-Nov-2017

11:11

Xlintl32.rest.idx_dll_1033

Xlintl32.rest.idx_dll

15.0.4703.1000

407,232

15-Nov-2017

11:11

Xllex.dll_1033

Xllex.dll

15.0.4569.1000

37,568

15-Nov-2017

11:11

x86

excel-x-none.msp file information

File identifier

File name

File version

File size

Date

Time

Excel.exe

Excel.exe

15.0.4989.1000

25,712,296

15-Nov-2017

11:11

Excel.man

Excel.exe.manifest

Not applicable

1,227

15-Nov-2017

11:11

Xl12cnv.exe

Excelcnv.exe

15.0.4989.1000

21,958,312

15-Nov-2017

11:11

Xl12cnvp.dll

Excelcnvpxy.dll

15.0.4454.1000

46,144

15-Nov-2017

11:11

Exptoows.xla.1033

Exptoows.xla

Not applicable

100,864

15-Nov-2017

11:11

Solver.xlam_1033

Solver.xlam

Not applicable

408,981

16-Nov-2017

11:01

Solver32.dll_1033

Solver32.dll

15.0.4454.1000

173,112

15-Nov-2017

11:10

Xlcall32.dll

Xlcall32.dll

15.0.4454.1000

10,328

15-Nov-2017

11:11

Xlicons.exe

Xlicons.exe

15.0.4553.1000

3,685,544

15-Nov-2017

11:10

Xlintl32.dll_1033

Xlintl32.dll

15.0.4703.1000

4,421,312

15-Nov-2017

11:10

Xlintl32.rest.idx_dll_1033

Xlintl32.rest.idx_dll

15.0.4703.1000

407,232

15-Nov-2017

11:10

Xllex.dll_1033

Xllex.dll

15.0.4569.1000

37,568

15-Nov-2017

11:10

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!

×