Microsoft KB Archive/284881

= The matching cell in the unselected worksheets are also replaced when you click the Replace All button in the Find and Replace dialog box in Excel =

Article ID: 284881

Article Last Modified on 2/1/2007

-

APPLIES TO


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

-



This article was previously published under Q284881





SYMPTOMS
When you select multiple, but not all, worksheets in a Microsoft Excel workbook, and then click the Replace All button in the Find and Replace dialog box, matching cells in unselected worksheets may be also be replaced.



CAUSE
This behavior can occur if the following conditions are true:
 * In Microsoft Office Excel and in earlier versions of Excel, you click Replace or Find on the Edit menu when multiple, but not all, worksheets are selected.

In Microsoft Office Excel 2007, you click Find & Select in the Editing group on the Home tab, and then click Replace or Find when multiple, but not all, worksheets are selected.
 * You specify Workbook in the Within box on the Replace tab of the Find and Replace dialog box.

Under these conditions, all worksheets in the workbook are searched for matching cells. Therefore, all matching cells are replaced.



WORKAROUND
To work around this issue and replace only cells in selected (grouped) worksheets, follow these steps:
 * 1) Start Microsoft Excel, and then open the workbook.
 * 2) Select the group of worksheets.
 * 3) On the Edit menu, click Replace.

Note In Excel 2007, click Find & Select in the Editing group on the Home tab, and then click Replace.
 * 1) On the Replace tab, specify the text that you want in the Find what and Replace with boxes.
 * 2) Click Options to display the advanced search options. Click the drop-down arrow in the Within box, and then click Sheet.
 * 3) Click Replace All.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
When you select Workbook in the Within box, the options in the Find and Replace dialog box handle the search for multiple selected worksheets in two different ways:
 * The Replace, Find All, and Find Next commands search only the selected worksheets.
 * The Replace All command searches all worksheets in the workbook.

When you select Sheets in the Within box, only the selected sheets are searched for matching cells.

Additional query words: XL2002 XL2003 XL2007

Keywords: kbexpertisebeginner kbprb kbtshoot kbbug kbpending KB284881

-

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

© Microsoft Corporation. All rights reserved.