XL98: Defined Name "Database" Is Deleted When You Use a Data Form

ID: Q181898


The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition


SYMPTOMS

When you use Microsoft Excel 98 Macintosh Edition, a defined name that you previously created in a workbook may be missing.


CAUSE

This problem may occur when the following conditions are true:

  • You select cells that are in one row only in an Excel worksheet.


  • -and-

  • You define a name as "Database" (point to Name on the Insert menu and click Define).


  • -and-

  • You have attempted to use a data form (click Form on the Data menu).



WORKAROUND

To workaround this problem, use one of the following methods:

  • Ensure that the defined name consists of cells that are located in more than one row.


  • -or-

  • Use a defined name other than "Database."



STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.


REFERENCES

For more information about defined names, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Microsoft Excel Help, type the following text

names, formulas or constants
and then click Show Topics. Select the "Change the name for a reference, formula, or constant" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant.

Additional query words: XL98

Keywords :
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbbug


Last Reviewed: January 13, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.