Home

Excel 2016 Find Replace not working on same columns multiple sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-861926%22%20slang%3D%22en-US%22%3EExcel%202016%20Find%20Replace%20not%20working%20on%20same%20columns%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861926%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20years%20I%20have%20been%20able%20to%20select%20multiple%20tabs%20(7%2B)%20and%20highlight%20the%20same%20columns%20and%20use%20the%20Find%2FReplace%20function%20(within%20Sheet)%20to%20update%20formulas.%26nbsp%3B%20Recently%20this%20stopped%20functioning%20and%20only%20lets%20me%20do%202%20sheets%20at%20a%20time%20(sometimes).%26nbsp%3B%20I%20am%20using%20Excel%202016%20and%20the%20file%20type%20is%20a%20Macro%20Enabled%20Workbook.%26nbsp%3B%20Changing%20the%20Within%20from%20Sheet%20to%20Workbook%20is%20not%20an%20option%20as%20it%20effects%20other%20formulas.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-861926%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-889004%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%20Find%20Replace%20not%20working%20on%20same%20columns%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-889004%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411385%22%20target%3D%22_blank%22%3E%40SidNee201%3C%2FA%3E%26nbsp%3BHave%20you%20figured%20out%20a%20solution%20to%20this%3F%26nbsp%3B%20I%20am%20having%20the%20same%20problem%20and%20need%20to%20be%20able%20to%20select%20more%20than%202%20sheets%20at%20a%20time.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-898218%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%20Find%20Replace%20not%20working%20on%20same%20columns%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-898218%22%20slang%3D%22en-US%22%3EI'm%20also%20having%20the%20same%20problem.%20Have%20you%20found%20a%20solution%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-900115%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%20Find%20Replace%20not%20working%20on%20same%20columns%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-900115%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411385%22%20target%3D%22_blank%22%3E%40SidNee201%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20news%20regarding%20this%3F%26nbsp%3B%20Was%20an%20issue%20last%20month%2C%20thought%20I%20might%20have%20changed%20some%20setting%20but%20after%20review%2C%20did%20not.%26nbsp%3B%20Still%20an%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E
SidNee201
Occasional Visitor

For years I have been able to select multiple tabs (7+) and highlight the same columns and use the Find/Replace function (within Sheet) to update formulas.  Recently this stopped functioning and only lets me do 2 sheets at a time (sometimes).  I am using Excel 2016 and the file type is a Macro Enabled Workbook.  Changing the Within from Sheet to Workbook is not an option as it effects other formulas. 

3 Replies

@SidNee201 Have you figured out a solution to this?  I am having the same problem and need to be able to select more than 2 sheets at a time.

I'm also having the same problem. Have you found a solution?

@SidNee201 

 

Any news regarding this?  Was an issue last month, thought I might have changed some setting but after review, did not.  Still an issue.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies