Excel: Unable to Use Data Form with Linked Spreadsheets

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 "Database" is defined as "=Worksheet1!Database", when Form is chosen from the Data menu with Worksheet2 active, the error message "Database Range is not Valid" will be generated.

To use the Form command, "Database" 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 "Micorsoft Excel User's Guide" version 3.0 manual. If you are using Excel 2.20, see pages 157-166 of the "Microsoft Excel Reference" version 2.2 manual.


KBCategory: kbother
KBSubcategory:

Additional reference words: noupd


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: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.