Difference between revisions of "Microsoft KB Archive/104499"

From BetaArchive Wiki
(importing KB archive)
 
m (Text replacement - """ to """)
 
Line 75: Line 75:
 
In earlier versions of Microsoft Excel, when you double-click a cell that contains a cell note, the note is displayed. If the cell contains an external link, the linked worksheet opens, and the linked information is selected. If the cell contains a formula, the cells that the formula refers to (precedents) are selected.<br />
 
In earlier versions of Microsoft Excel, when you double-click a cell that contains a cell note, the note is displayed. If the cell contains an external link, the linked worksheet opens, and the linked information is selected. If the cell contains a formula, the cells that the formula refers to (precedents) are selected.<br />
 
<br />
 
<br />
In Microsoft Excel versions 5.0 and later, you can directly edit the contents of a cell by double-clicking the cell. However, if you double- click a locked cell on a protected worksheet, editing directly in the cell is not allowed. In this case, you receive the error message &quot;Locked cells cannot be changed,&quot; and the Microsoft Excel 4.0 behavior occurs.<br />
+
In Microsoft Excel versions 5.0 and later, you can directly edit the contents of a cell by double-clicking the cell. However, if you double- click a locked cell on a protected worksheet, editing directly in the cell is not allowed. In this case, you receive the error message "Locked cells cannot be changed," and the Microsoft Excel 4.0 behavior occurs.<br />
 
<br />
 
<br />
 
For example, if you double-click a locked cell that contains a cell note, you receive the locked cells error message, and then the note is displayed. If you double-click a locked cell that contains a link, the locked cells error message appears, and then the file that contains the linked information opens. If you double-click a locked cell that contains a precedent, the error message appears, and the cells that the formula refers to are selected.
 
For example, if you double-click a locked cell that contains a cell note, you receive the locked cells error message, and then the note is displayed. If you double-click a locked cell that contains a link, the locked cells error message appears, and then the file that contains the linked information opens. If you double-click a locked cell that contains a precedent, the error message appears, and the cells that the formula refers to are selected.
Line 82: Line 82:
 
<br />
 
<br />
  
Additional query words: 5.00a 5.00c 7.00a 97 98 XL98 XL97 XL7 XL5 links in-place &quot;in place editing&quot; show XL
+
Additional query words: 5.00a 5.00c 7.00a 97 98 XL98 XL97 XL7 XL5 links in-place "in place editing" show XL
  
 
Keywords: kbprb KB104499
 
Keywords: kbprb KB104499

Latest revision as of 09:34, 20 July 2020

Knowledge Base


Article ID: 104499

Article Last Modified on 8/15/2003



APPLIES TO

  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 98 for Macintosh



This article was previously published under Q104499

SYMPTOMS

In Microsoft Excel, when you double-click a cell that contains a note, a link to another worksheet, or a precedent, a flashing bar appears in the cell instead of the expected behavior; displaying the note, linked worksheet, or precedent.

CAUSE

In Microsoft Excel, when you double-click a cell, a flashing bar appears, and then you can edit directly in the cell. If you want to display cell notes or select a cell's precedents, use one of the workarounds in this article.

WORKAROUND

To work around this problem, do one of the following:

  • Clear the Edit Directly In Cell check box on the Edit tab in the Options dialog box (click Options or Preferences on the Tools menu). After you clear this option, when you double-click a cell, the note is displayed or the linked information or precedents are selected.


-or-

  • Instead of double-clicking a cell to display cell notes or select precedents, use the Attach Note and Trace Precedents buttons. These buttons are located on the Auditing toolbar. You can also display a cell note by pressing SHIFT+F2.


MORE INFORMATION

In earlier versions of Microsoft Excel, when you double-click a cell that contains a cell note, the note is displayed. If the cell contains an external link, the linked worksheet opens, and the linked information is selected. If the cell contains a formula, the cells that the formula refers to (precedents) are selected.

In Microsoft Excel versions 5.0 and later, you can directly edit the contents of a cell by double-clicking the cell. However, if you double- click a locked cell on a protected worksheet, editing directly in the cell is not allowed. In this case, you receive the error message "Locked cells cannot be changed," and the Microsoft Excel 4.0 behavior occurs.

For example, if you double-click a locked cell that contains a cell note, you receive the locked cells error message, and then the note is displayed. If you double-click a locked cell that contains a link, the locked cells error message appears, and then the file that contains the linked information opens. If you double-click a locked cell that contains a precedent, the error message appears, and the cells that the formula refers to are selected.


Additional query words: 5.00a 5.00c 7.00a 97 98 XL98 XL97 XL7 XL5 links in-place "in place editing" show XL

Keywords: kbprb KB104499