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%3CLINGO-SUB%20id%3D%22lingo-sub-927265%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-927265%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F422300%22%20target%3D%22_blank%22%3E%40JJJ1969%3C%2FA%3E%26nbsp%3B%20I%20have%20consulted%20with%20MANY%20users%20and%20had%20no%20luck%20finding%20a%20solution.%26nbsp%3B%20It%20appears%20that%20this%20happened%20after%20a%20update%20was%20installed.%26nbsp%3B%20I%20was%20hoping%20a%20MS%20%22expert%22%20would%20weigh%20in%20on%20this%20but%20have%20heard%20nothing.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-968716%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-968716%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%3EHave%20you%20heard%20anything%20about%20how%20to%20fix%20this%3F%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20came%20across%20this%20problem%20a%20few%20days%20ago%2C%20since%20having%20some%20software%20updates.%26nbsp%3B%20I%20need%20this%20to%20be%20correctly%20asap.%26nbsp%3B%20I%20can't%20work%20on%20building%20templates%20if%20this%20is%20not%20working...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-969089%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-969089%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%3EIt%20was%20due%20to%20a%20software%20update%20that%20had%20recently%20got%20pushed%20through%20at%20my%20office.%26nbsp%3B%20I%20had%20them%20un-install%20and%20re-install%20excel%202016%20and%20it%20seems%20to%20be%20working%20fine%20for%20now.%26nbsp%3B%20I%20may%20have%20them%20revert%20me%20back%20to%20Excel%202013%20or%20earlier%20unless%20it%20gets%20fixed%20in%202016.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20guessing%20it%20will%20happen%20again%20once%20I%20am%20forced%20to%20do%20a%20software%20update%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-969816%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-969816%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20interested%20in%20the%20official%20documentation%20of%20this%20change%20if%20it%20exists%20in%20the%20updates%20history%20somewhere.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1016208%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-1016208%22%20slang%3D%22en-US%22%3E%3CP%3EFacing%20same%20problem%20here%20too..%20we%20need%20a%20fix%20for%20this%3C%2FP%3E%3C%2FLINGO-BODY%3E
SidNee201
New Contributor

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. 

8 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.

Highlighted
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.

@JJJ1969  I have consulted with MANY users and had no luck finding a solution.  It appears that this happened after a update was installed.  I was hoping a MS "expert" would weigh in on this but have heard nothing.

@SidNee201 

 

Have you heard anything about how to fix this???

 

I came across this problem a few days ago, since having some software updates.  I need this to be correctly asap.  I can't work on building templates if this is not working...

@SidNee201 

 

It was due to a software update that had recently got pushed through at my office.  I had them un-install and re-install excel 2016 and it seems to be working fine for now.  I may have them revert me back to Excel 2013 or earlier unless it gets fixed in 2016.

 

I am guessing it will happen again once I am forced to do a software update again.

I'm interested in the official documentation of this change if it exists in the updates history somewhere.

Facing same problem here too.. we need a fix for this

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
37 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies