Microsoft KB Archive/285347

= XL: Illegal Operation Error When You Attempt to Format Cells =

Article ID: 285347

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition
 * Microsoft Windows 95
 * Microsoft Windows 98 Standard Edition

-



This article was previously published under Q285347



IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry



SYMPTOMS
When you attempt to format a cell (by using toolbar buttons or menus), you may receive the following error message:

This program has performed an illegal operation and will be shut down. If the problem persists, contact the program vendor.

If you click Details, you receive an error message similar to the following:

EXCEL caused an invalid page fault in module EXCEL.EXE at 015f:3007abc7



CAUSE
This problem may occur if either of the following registry keys contains a missing or incorrect entry:

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Nls\Locale

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Nls\AddLocales

These keys contain all of the locale settings that are under Regional Settings in Control Panel. If one of these keys is missing, your regional settings are blank.



RESOLUTION
To resolve this problem, use either of the following methods to restore the missing or incorrect registry keys.

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

Method 1: Download the Keys from Microsoft
First, download the Locale.reg file from Microsoft. The following file is available for download from the Microsoft Download Center:

Download Locale.reg now

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used 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 to prevent any unauthorized changes to the file. After you download the Locale.reg file, follow these steps:  Click Start, and then click Run. In the Open box, type regedit, and then click OK. In the left pane of Registry Editor, locate and select the following key (folder) if present:

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Nls\Locale

The next two steps are only necessary if the Locale key is present:  On the Edit menu, click Rename. Rename the key to OldLocale .</ol> </li> In the left pane of Registry Editor, locate and select the following key (folder) if present:

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Nls\AddLocales

The next two steps are only necessary if the AddLocales key is present: <ol style="list-style-type: lower-alpha;"> On the Edit menu, click Rename.</li> Rename the key to OldAddLocales .</li></ol> </li> On the Registry menu, click Exit.</li> Locate and double-click the Locale.reg file that you downloaded earlier.</li> Click Yes when you are prompted as follows:

Are you sure you want to add the information in locale.reg to the registry?

</li> Click OK when you are prompted as follows:

Information in the locale.reg has been successfully entered into the registry.

</li> Restart Windows.</li> Click Start, point to Settings, and then click Control Panel.</li> Double-click the Regional Settings icon, and verify that several country choices are listed.</li></ol>

Add the Locale Key
<ol> Click Start, and then click Run.</li> In the Open box, type regedit, and then click OK.</li> In the left pane of Registry Editor, locate and select the following key (folder) if present:

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Nls

Before you proceed to the next step, verify that the Nls key does not contain the Locale key. If the Locale key exists, skip to the &quot;Add the AddLocales Key&quot; section later in this article.</li> With the NLS key selected, point to New on the Edit menu, and then click Key.</li> With New Key #1 selected, type Locale and then press ENTER.</li> With the Locale key selected, double-click the (Default) value in the right pane of Registry Editor.</li> <li>In the Value data box, type 00000409, and then press ENTER.</li> <li>On the Edit menu, point to New, and then click String Value.</li> <li>With New Value #1 selected, type 00000409, and then press ENTER.</li> <li>In the right pane of Registry Editor, double-click the 00000409 value.</li> <li>In the Value data box, type English (United States), and then press ENTER.</li> <li>On the Registry menu, click Exit.</li> <li>Restart Windows.</li> <li>Click Start, point to Settings, and then click Control Panel.</li> <li>Double-click the Regional Settings icon, and verify that your current locale is English (United States).</li></ol>

Add the AddLocales Key
<ol> <li>Click Start, and then click Run.</li> <li>In the Open box, type regedit, and then click OK.</li> <li>In the left pane of Registry Editor, locate and select the following key (folder) if present:

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Nls

Before you proceed to the next step, verify that the Nls key does not contain the AddLocales key. If the AddLocales key exists, click Exit on the Registry menu and stop here; no further steps are necessary.</li> <li>On the Edit menu, point to New, and then click Key.</li> <li>With New Key #1 selected, type AddLocales, and then press ENTER.</li> <li>With the AddLocales key selected, double-click the (Default) value in the right pane of Registry Editor.</li> <li>Press ENTER to enter a blank value.</li> <li>On the Registry menu, click Exit.</li> <li>Restart Windows.</li> <li>Click Start, point to Settings, and then click Control Panel.</li> <li>Double-click the Regional Settings icon, and verify that your current locale is English (United States).</li></ol>

Additional query words: XL2000 XL97 0167:3009aa90 015f:3009aa90 ipf crash formatting

Keywords: kbdownload kbdownload kberrmsg kbfile kbgraphxlink kbprb KB285347

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.