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

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

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies