Microsoft KB Archive/32989

Excel 1.50: Custom Number Format From Macro Causes Corruption PSS ID Number: Q32989 Article last modified on 01-23-1991 PSS database name: M_eXceL

1.00 1.03 1.04 1.06 1.50

MACINTOSH

Summary:

If a macro is used to record the formatting of a selection for a custom number format in Microsoft Excel versions 1.0x, having the macro or any file that has had the macro run on it open causes odd behavior, including crashes. This occurs because of a problem that was discovered and addressed in version 1.50.

To correct the problem, do the following:


 * 1) Save the file in version 1.50 in SYLK file format.
 * 2) Read the file back into Excel 1.50. You will get a read error when opening the file.
 * 3) Click OK and the bad record will be skipped. Usually, the bad record is number 22.

More Information:

This procedure will not harm any step on the macro sheet or any data on the worksheet; the file will operate properly. Saving the file as SYLK restores the file to a correct state.

Copyright Microsoft Corporation 1991.