# Microsoft Knowledge Base

## XL Err Msg: "Database or List Range Not Valid" with Data Form

Last reviewed: March 27, 1997 Article ID: Q118992
5.00 5.00c 7.00 7.00a | 5.00 5.00a WINDOWS | MACINTOSH kbprb The information in this article applies to:

- Microsoft Excel for Windows 95, versions 7.0, 7.0a
- Microsoft Excel for Windows, versions 5.0, 5.0c
- Microsoft Excel for Windows NT, version 5.0
- Microsoft Excel for the Macintosh, versions 5.0, 5.0a

## SYMPTOMS

In the versions of Microsoft Excel mentioned above, when "Database" is defined as a global name that refers to a non-active sheet, activating the Data Form will cause the following error message (even if you have a valid list on the active sheet):

       Database or List Range is Not Valid

## CAUSE

Although the Data Form can be used to update data on the current sheet only, when you choose Form from the Data menu, Microsoft Excel still attempts to find the region defined by the global name "Database." If Microsoft Excel cannot access this information (in this case because the information is located on another sheet and that sheet is closed), the "Not Valid" error message is returned.

## WORKAROUND

To use the Data Form on several worksheets, do the following to define "Database" locally on each worksheet:

1. Select the database range.

2. From the Insert menu, choose Name, and then choose Define.

3. Type "mysheet!Database" where mysheet is the name of the active sheet.

4. Choose the OK button.

> KBCategory: kbprb
> KBSubcategory:

> Additional reference words: 5.00 5.00a 5.00c 7.00 7.00a

> Keywords : kbprb
> Version : 5.00 5.00c 7.00 7.00a | 5.00 5.0
> Platform : MACINTOSH WINDOWS

> THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 27, 1997
©1997 Microsoft Corporation. All rights reserved. Legal Notices.