Microsoft KB Archive/279306

= Error checking is not available when worksheet is protected or workbook is shared in Excel =

Article ID: 279306

Article Last Modified on 2/8/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q279306



SYMPTOMS
When you enter a formula error, such as &quot;divide by zero,&quot; in a worksheet cell, the Error Checking Smart Tag (the floating command and message box) does not appear as expected. Additionally, the Error Checking command is not available.



CAUSE
This behavior can occur because Error Checking is not available when the worksheet is protected or when the workbook is shared.



RESOLUTION
To make the Error Checking command available, make sure that the worksheet is unprotected and the workbook is not shared. To do so, use the appropriate method, as follows. For a Protected Worksheet
 * 1) In Microsoft Office Excel 2007, click the Formulas tab. Error Checking is not available (appears dimmed) in the Formula Auditing group. Click the Review tab, and then click Unprotect Sheet in the Changes group.

In Microsoft Office Excel 2003 and in earlier versions of Excel, Error Checking is not available (appears dimmed) on the Tools menu. On the Tools menu, point to Protection, and then click Unprotect Worksheet.

Error Checking is now available.

For a Shared Workbook

 * 1) In Microsoft Office Excel 2007, click the Formulas tab, Error Checking is not available (appears dimmed) in the Formula Auditing group. Click the Review tab, and then click Share Workbook in the Changes group.

In Microsoft Office Excel 2003 and in earlier versions of Excel, the Error Checking command is not available (appears dimmed) on the Tools menu. On the Tools menu, click Share Workbook.
 * 1) In the Share Workbook dialog box, click to clear the Allow changes by more than one user at the same time check box.
 * 2) Click OK.
 * 3) You are prompted with the question, &quot;Remove the workbook from shared use?&quot; Click Yes.

The Error Checking command is now available.



MORE INFORMATION
In Excel 2007, worksheets can be protected by clicking the Review tab, and then clicking Protect Sheet in the Changes group.

In Excel 2003 and in earlier versions of Excel, worksheets can be protected by pointing to Protection and then clicking Protect Worksheet on the Tools menu.

In Excel 2007, workbooks can be shared by clicking the Review tab, and then clicking Share Workbook in the Changes group.

In Excel 2003 and in earlier versions of Excel, workbooks can be shared by clicking Share Workbook on the Tools menu and then clicking to select the Allow changes by more than one user at the same time check box.

Additional query words: XL2002 prb XL2003

Keywords: kbpending kbprb KB279306

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.