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%3CLINGO-SUB%20id%3D%22lingo-sub-1057181%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-1057181%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20have%20the%20same%20issue%20since%202%20or%203%20months%2C%20Here%20are%20the%20steps%20to%20reproduce%3A%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E1)%20Open%20workbook%20with%20multiple%20sheets%20(mine%20having%2013%20sheet)%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2)%20Right-click%20on%20a%20sheet%20and%20Select%20All%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E3)%20Select%20a%20bunch%20of%20cells%20that%20have%20values%20that%20you%20want%20to%20replace%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E4)%20Ctrl%2Bh%20to%20open%20the%20replace%20tool%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E5)%20Type%20in%20the%20Find%20what%3A%20and%20the%20Replace%20with%3A%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E6)%20Click%20on%20Replace%20All%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EReplace%20will%20work%20only%20for%20the%20current%20active%20sheet%20and%20next%20one%20in%20selected%20only%2C%20other%20selected%20sheets%20will%20not%20replaced.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1057320%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-1057320%22%20slang%3D%22en-US%22%3E%3CP%3ESame%20problem%20here.%3C%2FP%3E%3CP%3EWork%20in%20company%20and%20this%20is%20part%20of%20daily%20routine%20among%20several%20excel%20files.%3C%2FP%3E%3CP%3EIt%20can't%20be%20so%20hard%20to%20sort%20it%20out..%20come%20on!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1057791%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-1057791%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F483677%22%20target%3D%22_blank%22%3E%40MomaniSM%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFYI%20-%20Although%20only%202%20sheets%20will%20be%20changed%20when%20more%20are%20selected%2C%20the%20cells%20are%20still%20highlighted%20on%20all%20selected%20sheets%20just%20not%20changed%20on%20all%20sheets.%26nbsp%3B%20Just%20have%20to%20select%20each%20tab%20not%20changed%20individually%20and%20select%20Replace%20(all)%20only%20since%20the%20cells%20will%20already%20be%20highlighted.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStill%20takes%20bit%20of%20extra%20work%20but%20at%20least%20you%20won't%20have%20to%20re-highlight%20the%20cells%20on%20the%20tabs%20that%20did%20not%20change.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1058391%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-1058391%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20seems%20to%20be%20an%20issue%20that%20Microsoft%20is%20ignoring.%20Anyone%20have%20an%20idea%20how%20to%20raise%20more%20awareness%20or%20get%20MS%20to%20fix%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1058444%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-1058444%22%20slang%3D%22en-US%22%3E%3CP%3EI%20had%20my%20IT%20department%20uninstall%20and%20reinstall%20excel.%26nbsp%3B%20They%20had%20to%20do%20it%20a%20few%20times%20because%20Microsoft%20kept%20trying%20to%20push%20me%20to%20update.%26nbsp%3B%20Ignore%20the%20updates%20until%20it%20forces%20you%20to%20do%20it.%26nbsp%3B%20After%20like%20the%203rd%20reinstall%2C%20it%20seems%20to%20be%20working%20fine...%20for%20now....%20going%20on%201%20month%20without%20issue.%3C%2FP%3E%3CP%3EAnother%20option%20I%20am%20seeing%20is%20reverting%20back%20to%202013%20version.%20I%20know%20this%20is%20not%20an%20ideal%20solution%20but%20not%20being%20to%20able%20to%20work%20on%20multiple%20tabs%20is%20taking%20up%20precious%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20no%20clue%20how%20to%20escalate%20to%20MS.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1093041%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-1093041%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYay!%26nbsp%3B%20This%20appears%20to%20be%20fixed.%26nbsp%3B%20At%20least%20it's%20working%20today.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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. 

14 Replies
Highlighted

@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?
Highlighted

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

Highlighted

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

Highlighted

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

Highlighted

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

Highlighted

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

Highlighted

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

Highlighted

I have the same issue since 2 or 3 months, Here are the steps to reproduce: 
1) Open workbook with multiple sheets (mine having 13 sheet) 
2) Right-click on a sheet and Select All 
3) Select a bunch of cells that have values that you want to replace 
4) Ctrl+h to open the replace tool 
5) Type in the Find what: and the Replace with: 
6) Click on Replace All 

 

Replace will work only for the current active sheet and next one in selected only, other selected sheets will not replaced.

Highlighted

Same problem here.

Work in company and this is part of daily routine among several excel files.

It can't be so hard to sort it out.. come on!

Highlighted

@MomaniSM 

 

FYI - Although only 2 sheets will be changed when more are selected, the cells are still highlighted on all selected sheets just not changed on all sheets.  Just have to select each tab not changed individually and select Replace (all) only since the cells will already be highlighted.

 

Still takes bit of extra work but at least you won't have to re-highlight the cells on the tabs that did not change. 

Highlighted

This seems to be an issue that Microsoft is ignoring. Anyone have an idea how to raise more awareness or get MS to fix?

Highlighted

I had my IT department uninstall and reinstall excel.  They had to do it a few times because Microsoft kept trying to push me to update.  Ignore the updates until it forces you to do it.  After like the 3rd reinstall, it seems to be working fine... for now.... going on 1 month without issue.

Another option I am seeing is reverting back to 2013 version. I know this is not an ideal solution but not being to able to work on multiple tabs is taking up precious time.

 

I have no clue how to escalate to MS.

 

 

Highlighted

 

Yay!  This appears to be fixed.  At least it's working today.