Microsoft KB Archive/63803

{| = Excel: Unable to Use Data Form with Linked Spreadsheets =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q63803

SUMMARY
In Microsoft Excel, the Form command on the Data menu cannot be used when the database does not reside on the active worksheet.

If the database resides on Worksheet1, and on Worksheet2 the word &quot;Database&quot; is defined as &quot;=Worksheet1!Database&quot;, when Form is chosen from the Data menu with Worksheet2 active, the error message &quot;Database Range is not Valid&quot; will be generated.

To use the Form command, &quot;Database&quot; must be defined on the active worksheet and must refer to cells on that worksheet.

Database functions, such as DSUM and DCOUNT, work as expected.

For more information on using data forms, see pages 356-365 of the &quot;Micorsoft Excel User's Guide&quot; version 3.0 manual. If you are using Excel 2.20, see pages 157-166 of the &quot;Microsoft Excel Reference&quot; version 2.2 manual.
 * }