XL: "Database Range Not Defined"/Data Missing Saving to dBASE (31817)
The information in this article applies to:
- Microsoft Excel for Windows 2.0
- Microsoft Excel for Windows 2.01
- Microsoft Excel for Windows 2.1
- Microsoft Excel for Windows 2.10c
- Microsoft Excel for Windows 2.10d
- Microsoft Excel for Windows 3.0
- Microsoft Excel for Windows 3.0a
- Microsoft Excel for Windows 4.0
- Microsoft Excel for Windows 4.0a
- Microsoft Excel for Windows 4.0c
- Microsoft Excel for Windows 5.0
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for Windows 95
This article was previously published under Q31817 SYMPTOMS
In Microsoft Excel, if a database is not defined on the worksheet, you may
receive one of the following error messages when you save a worksheet to
the dBASE (.DBF) file format:
Database range is not defined
No list found. Select a single cell within your list and Microsoft Excel
will select the list for you.
Also note that only the data that is in the database range is saved to the
.DBF file. (Other data on the worksheet are lost when you save the file in
this file format.)
CAUSE
In Microsoft Excel, you must define a database on the worksheet before you
save it in the dBASE file format.
WORKAROUND
To define a database on a worksheet so that you can save it in a dBASE file
format, follow these steps:
- On the Microsoft Excel worksheet, select the range that contains the
database.
- In Excel 5.0 and later, click the Name Box, type Database and press
ENTER. (This is equivalent to creating a defined name called Database).
In Excel 4.x and earlier, click Set Database on the Data menu.
- Save the file in the dBASE file format you want.
NOTE: When you add records to an old .DBF file, you must remember to extend
the database range so that the new data can be saved.
Modification Type: | Minor | Last Reviewed: | 8/16/2005 |
---|
Keywords: | kberrmsg kbprb kbusage KB31817 |
---|
|