This article describes the issues that are fixed in the Microsoft Excel 2013 hotfix package that is dated December 10, 2013.
Issues that this hotfix package fixes
When you click a button to run a macro to protect or unprotect some worksheets in a workbook in Excel 2013, the sheet focus changes instead of staying on the sheet that contains the button.
Assume that you create a workbook that contains links to external workbooks that are not stored on your own computer. When you open the workbook, it takes longer than expected.
Assume that you set two passwords for a range in a Microsoft Excel 2010 workbook. When you use one of the passwords to unlock the range, the range is not unlocked and you receive the following error message:
The password you supplied is not correct. Verify that the CAPS LOCK key is off and be sure to use the correct capitalization.
Assume that you create a workbook that contains links to external workbook in Excel 2013, and the external workbook requires a password to be opened for editing. When you open the external workbook as read-only, the links to the external workbook may become corrupted.
Assume that you insert an Excel worksheet object that contains one or more ActiveX controls in run mode to another Office application. When you activate and deactivate the Excel object, Excel 2013 crashes.
Consider the following scenario:
You set the Taskbar buttons value to Always combine, hide labels in the taskbar properties.
You create a workbook that contains a WorkbookBeforeClose event to prevent closing the workbook.
You select Close all windows on the taskbar to close grouped workbooks.
You cancel the close operation from a dialog or prompt that is displayed in the WorkbookBeforeClose event.
In this situation, the workbook is still closed.
Fixes a crash that can occur if you have applied the KB 2837666 update for the PowerPivot add-in.
A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing the problem described in this article. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.
If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix.
Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft website:
http://support.microsoft.com/contactus/?ws=supportNote The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.
To install this hotfix package, you must have Excel 2013 installed.
You do not have to restart the computer after you install this hotfix.
Hotfix replacement information
This hotfix does not replace a previously released hotfix.
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.
After you install the hotfix package, you can follow these steps to enable this hotfix:
Click Start, click Run, type regedit in the Open box, and then click OK.
Locate and then select the following registry subkey:
On the Edit menu, point to New, and then click DWORD Value.
Type ExcelResetSheetAfterProtection, and then press Enter.
In the Details pane, right-click ExcelResetSheetAfterProtection, and then click Modify.
In the Value data box, type 1, and then click OK.
Exit Registry Editor.
This hotfix package may not contain all the files that you must have to fully update a product to the latest build. This hotfix package contains only the files that you must have to resolve the issue that listed in this article.
The global version of this hotfix package uses a Microsoft Windows Installer package to install the hotfix package. The dates and the times for these files are listed in Coordinated Universal Time (UTC) in the following table. When you view the file information, the date is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.