The information in this article applies to:
SYMPTOMSWhen you open a workbook that does not contain macros, you may receive the following message: If you click Disable Macros, you may receive the additional message: If you click Yes, the workbook opens. If you click No, the workbook does not open. When you open the workbook, you are unable to find any macros. CAUSE
This problem may occur when the following conditions are true:
WORKAROUNDAssign the name to refer to a cell address and type 1.5 in the cell. STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. MORE INFORMATIONIf you delete the defined name or change the value, the error no longer occurs. REFERENCESFor more information about cell names, click Contents and Index
on the Help menu, click the Index tab in Excel Help, type the
following text naming, cellsand then double-click the selected text to go to the "Determine what a name refers to" topic. If you are unable to find the information you need, ask the Office Assistant. Additional query words: XL97 named range alert
Keywords : kbdta |
Last Reviewed: January 18, 2000 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |