Microsoft KB Archive/172259

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 10:06, 21 July 2020 by X010 (talk | contribs) (Text replacement - """ to """)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base


XL97: Error Clicking Pick From List in Cell with Many Characters

Article ID: 172259

Article Last Modified on 10/22/2000



APPLIES TO

  • Microsoft Excel 97 Standard Edition



This article was previously published under Q172259

SYMPTOMS

In Microsoft Excel 97, if you right-click a cell and click Pick From List on the shortcut menu while the cell is in edit mode, 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 either of the following:

EXCEL caused an invalid page fault in module KERNEL32.DLL at 0137:bff9a5d0.

EXCEL caused an invalid page fault in module EXCEL.EXE at 0137:3000112e.

CAUSE

This problem occurs when the following conditions are true:

  • You edit a cell that contains 268 or more characters.


-and-

  • You immediately click anywhere in the worksheet without clicking an item in the Pick From list.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

In Microsoft Excel 97, you can use the Pick From List command to automatically enter text into a cell. When you use the Pick From List command, Microsoft Excel 97 generates a list by using the text from neighboring cells.

If you double-click a cell, or if you press F2, Microsoft Excel 97 places the cell in edit mode. If you right-click the cell, the Pick From List menu command appears on the shortcut menu.

If the cell that you are editing contains 268 or more characters, and you click Pick From List, and then click outside of the list, you receive the error message mentioned in the "Symptoms" section.


Additional query words: XL97 267 255 256 0137:300011c1

Keywords: kberrmsg kbbug KB172259