XL: Some Database Records Not Visible in Data Form

ID: Q98008

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 0S/2, versions 2.x and 3.0
Microsoft Excel for the Macintosh, versions 2.x, 3.0, 4.0, 5.0

SYMPTOMS

In Microsoft Excel, some database records are not be visible in the data form if either of the following conditions apply to any of the cells that contain the records:

The cells have a protection status of hidden and worksheet cells are protected.

-or-

The column is hidden because it has a column width of zero.

The data form, which reads information from the formula bar, cannot read from or write to cells that are Hidden or that have no column width. This is expected behavior with cells that are in hidden columns or that have been hidden by cell protection.

WORKAROUNDS

To have full data form functionality, do the following:

Format all columns in the database to have a nonzero width with the following steps:
1. Select the entire database.
2. In Microsoft Excel version 5.0, choose Column from the Format menu, and then choose Unhide.
  
  In Microsoft Excel versions 2.x, 3.0 and 4.0, choose Column Width from the Format menu, and then choose the Unhide button.
  
  -and-
3. Unhide all cells in the database if the cells on the worksheet are protected by using the following appropriate method.

Microsoft Excel Version 5.0
---------------------------

From the Tools menu, choose Protection, and then choose Unprotect Sheet. If a password is required to unprotect the sheet, enter the password and choose OK.

If you want to keep other cells on the worksheet protected, unhide only the cells in the database by taking the following steps:
1. Select the entire database. If you plan use the data form to add records to the database, you should also select additional cells below the database.
2. From the Format menu, choose Cells. Select the Protection tab. Clear the Hidden check box and choose OK.

If you want to protect the worksheet again, choose Protection from the Tools menu, and then choose Protect Sheet. In the Protect Sheet dialog box, choose OK to protect the worksheet. To keep the rest of the worksheet protected, but leave the cells unprotected, clear the Contents check box in the Protect Sheet dialog box before you choose OK.

Microsoft Excel versions 2.x, 3.0 and 4.0
-----------------------------------------

From the Options menu, choose Unprotect Document. If a password is required to unprotect the document, enter the password and choose OK.

If you want to keep other cells on the worksheet protected, you will need to unhide the cells in the database by taking the following steps:
1. Select the entire database. If you plan use the data form to add records to the database, you should also select additional cells below the database.
2. From the Format menu, choose Cell Protection. Clear the Hidden check box and choose OK.

If you want to protect the worksheet again, choose Protect Document from the Options menu. In the dialog box, choose OK to protect the worksheet. To keep the rest of the worksheet protected, but leave the cells unprotected, clear the Cells check box in the Protect Document dialog box before you choose OK.

NOTE: If you use a custom data form, you will be able to view data that is located in zero-width columns. However, as is the case with the standard data form, you cannot use a custom data form to enter data into hidden cells and you will not be able to view data that is entered in cells with a protection status of Hidden when the worksheet cells are protected.

REFERENCES

"Microsoft Excel User's Guide 1," version 4.0, pages 87-88
"Microsoft Excel User's Guide," version 3.0, pages 564-566

Additional query words: 2.00 2.01 2.10 2.10c 2.10d 2.21 4.00a dataform hide disappear


Keywords          : 
Version           : WINDOWS:2.0,3.0,4.0,5.0; OS/2:2.0,3.0; MACINTOSH:2.0,3.0,4.0,5.0
Platform          : MACINTOSH WINDOWS 
Issue type        : kbprb

Last Reviewed: April 2, 1999