Excel Err Msg: "Cannot Extend Database" with Data Form

ID: Q80485

The information in this article applies to:

Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
Microsoft Excel for the Macintosh, versions 2.2, 3.0, 4.0, 5.0

SUMMARY

You cannot add records to a database with the Microsoft Excel Form command (from the Data menu) if the database is on a protected document. This is true even when you want to place a new record in unlocked cells. The form appears when you choose the Form command, but when you enter new information, Microsoft Excel displays the error message:

Cannot Extend Database

All other database commands except Find are unavailable under these circumstances.

MORE INFORMATION

On protected documents, Microsoft Excel automatically removes commands that alter a worksheet's format or layout. The database cannot be extended because Microsoft Excel cannot insert rows or define names on a protected document. To redefine a database or to use certain database operations, choose Unprotect Document from the Options menu.

REFERENCES

"User's Guide 1," version 4.0, pages 84-90
"User's Guide," version 3.0 for the Macintosh, pages 556-561
"User's Guide," version 3.0 for Windows, pages 561-566

Additional query words: 2.00 2.01 2.10 2.20 4.00a

Keywords :
Version :
Platform :
Issue type :