Home

New Excel glitch - find and replace across multiple sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-894450%22%20slang%3D%22en-US%22%3ENew%20Excel%20glitch%20-%20find%20and%20replace%20across%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-894450%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20having%20an%20issue%20today%20with%20the%20find%20and%20replace%20function%20across%20multiple%20sheets%20in%20Excel.%26nbsp%3B%20I%20have%20a%20workbook%20with%20multiple%20sheets%20that%20are%20set%20up%20generally%20the%20same%20way%20so%20it's%20easy%20to%20select%20multiple%20sheets%20and%20highlight%20a%20row%20or%20column%20to%20edit%20the%20formula%20with%20the%20find%20and%20replace%20function.%26nbsp%3B%20Excel%20is%20glitching%20today%20and%20only%20changing%20the%20formula%20for%20two%20selected%20sheets%2C%20not%20all%20selected%20sheets.%26nbsp%3B%20I've%20tested%20this%20on%20multiple%20workstations%20at%20the%20office%20and%20encountering%20the%20same%20issue.%26nbsp%3B%20One%20workstation%20still%20works.%26nbsp%3B%20We're%20guessing%20it's%20because%20this%20workstation%20hasn't%20installed%20the%20latest%20Microsoft%20updates.%26nbsp%3B%20Anyone%20else%20having%20this%20issue%3F%26nbsp%3B%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-894450%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-894867%22%20slang%3D%22en-US%22%3ERe%3A%20New%20Excel%20glitch%20-%20find%20and%20replace%20across%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-894867%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420456%22%20target%3D%22_blank%22%3E%40DanielT2222%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20tried%20that%20with%206%20sheets%20and%20it%20worked%20as%20desired%20without%20an%20issue%20on%20my%20end.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-916145%22%20slang%3D%22en-US%22%3ERe%3A%20New%20Excel%20glitch%20-%20find%20and%20replace%20across%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-916145%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20the%20exact%20same%20issue.%20I%20only%20want%20to%20replace%20certain%20cells%20across%20many%20worksheets%20and%20it%20is%20only%20making%20the%20change%20to%20the%20first%20and%20the%20last%20worksheet%20and%20not%20the%20ones%20in%20between.%20This%20just%20stopped%20working%20after%20the%20latest%20update%20the%20pushed%20down.%26nbsp%3B%20Going%20to%20take%20so%20much%20longer%20to%20update%20all%20my%20files.%20So%20frustrating.%3C%2FP%3E%3C%2FLINGO-BODY%3E
DanielT2222
Occasional Visitor

I'm having an issue today with the find and replace function across multiple sheets in Excel.  I have a workbook with multiple sheets that are set up generally the same way so it's easy to select multiple sheets and highlight a row or column to edit the formula with the find and replace function.  Excel is glitching today and only changing the formula for two selected sheets, not all selected sheets.  I've tested this on multiple workstations at the office and encountering the same issue.  One workstation still works.  We're guessing it's because this workstation hasn't installed the latest Microsoft updates.  Anyone else having this issue?  Thanks.

2 Replies

@DanielT2222 

Just tried that with 6 sheets and it worked as desired without an issue on my end.

I am having the exact same issue. I only want to replace certain cells across many worksheets and it is only making the change to the first and the last worksheet and not the ones in between. This just stopped working after the latest update the pushed down.  Going to take so much longer to update all my files. So frustrating.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies