Home

find and replace

%3CLINGO-SUB%20id%3D%22lingo-sub-678348%22%20slang%3D%22en-US%22%3Efind%20and%20replace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-678348%22%20slang%3D%22en-US%22%3E%3CP%3EUsing%20the%20find%20and%20replace%20function%20but%20a%20window%20pops%20up%20for%20EVERY%20replacement%20where%20I%20have%20to%20select%20the%20new%20file.%26nbsp%3B%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-678348%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-678675%22%20slang%3D%22en-US%22%3ERE%3A%20find%20and%20replace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-678675%22%20slang%3D%22en-US%22%3EHi%20Bcurtis1%2C%20When%20you%20say%20select%20the%20new%20file%20what%20do%20you%20mean%3F%20Can%20you%20do%20Replace%20all%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-684006%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20find%20and%20replace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-684006%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20selecting%20ctrl%2Bh%2C%20entering%20my%20data%20and%20hitting%20enter.%26nbsp%3B%20The%20find%20data%20is%20from%20another%20computer%20so%20it's%20(simplified)%20E%5Cfile%5Cusethis%20lets%20say%20and%20I'm%20replacing%20to%20a%20file%20located%20on%20my%20desktop%20(WeekMay2).%26nbsp%3B%20When%20I%20hit%20replace%20all%2C%20I%20get%20a%20dialogue%20box%20that%20says%20Update%20Values%20WeekMay2.xls%2C%20it's%20opening%20a%20folder%20I%20have%20on%20my%20desktop%20w%2F%20the%20WeekMay2%20file%20in%20it%20-%20I%20then%20have%20to%20select%20the%20open%20the%20WeekMay2%20file%20for%20every%20replace%20I%20need%20to%20do.%26nbsp%3B%20There's%20around%2028k%20of%20them%2C%20so%20doing%20this%20by%20hand%20isn't%20an%20option.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20managed%20to%20work%20around%20this%20by%20only%20replacing%20the%20first%20cells%20across%20my%20row%20and%20then%20copying%20down%2C%20but%20I%20have%20to%20do%20this%20in%20multiple%20places%20and%20would%20prefer%20to%20find%2Freplace%20across%20the%20entire%20worksheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-736665%22%20slang%3D%22en-US%22%3ERe%3A%20find%20and%20replace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-736665%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F356740%22%20target%3D%22_blank%22%3E%40Bcurtis1%3C%2FA%3E%26nbsp%3BI%20am%20having%20a%20similar%20problem.%26nbsp%3B%20I%20am%20attempting%20to%20change%20all%20my%20cells%20from%20one%20reference%20sheet%20to%20another.%26nbsp%3B%20All%20I%20need%20to%20do%20is%20change%20the%20text%20in%20each%20formula%20from%20%22mar%22%20to%20%22jun%22%20in%20each%20cell%20and%20it%20will%20work.%26nbsp%3B%20I%20have%20done%20this%20in%20the%20past.%26nbsp%3B%20But%20excel%20is%20asking%20me%20to%20open%20a%20file%3F%26nbsp%3B%20Confused.%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F356740%22%20target%3D%22_blank%22%3E%40Bcurtis1%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3EUsing%20the%20find%20and%20replace%20function%20but%20a%20window%20pops%20up%20for%20EVERY%20replacement%20where%20I%20have%20to%20select%20the%20new%20file.%26nbsp%3B%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-736706%22%20slang%3D%22en-US%22%3ERe%3A%20find%20and%20replace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-736706%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F370650%22%20target%3D%22_blank%22%3E%40russell_rivera%3C%2FA%3EI%20may%20have%20found%20a%20sort%20of%20work%20around.%26nbsp%3B%20When%20opening%20the%20file%20I%20had%20the%20option%20to%20edit%20the%20links.%26nbsp%3B%20If%20I%20changed%20the%20links%20there%2C%20it%20worked%20faster.%26nbsp%3B%20And%2C%20once%20I%20got%20through%20this%20once%20it%20was%20ok%20going%20forward.%26nbsp%3B%20I've%20also%20found%20having%20the%20old%20file%20AND%20the%20new%20file%20open%20is%20helpful.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-736786%22%20slang%3D%22en-US%22%3ERe%3A%20find%20and%20replace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-736786%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F356740%22%20target%3D%22_blank%22%3E%40Bcurtis1%3C%2FA%3E%26nbsp%3BThanks%20for%20responding.%20I%20did%20find%20the%20source%20of%20my%20issue.%26nbsp%3B%20As%20it%20was%20saved%20in%20an%20'97-03%20format.%26nbsp%3B%20I%20had%20to%20find%20a%20legacy%20copy%20of%20the%20file%20(in%20'16%20format)%20and%20rebuild%20it%20(was%20just%20some%20copy%20and%20paste).%26nbsp%3B%20Thanks%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Bcurtis1
New Contributor

Using the find and replace function but a window pops up for EVERY replacement where I have to select the new file.  help!

 

5 Replies
Hi Bcurtis1, When you say select the new file what do you mean? Can you do Replace all?

I'm selecting ctrl+h, entering my data and hitting enter.  The find data is from another computer so it's (simplified) E\file\usethis lets say and I'm replacing to a file located on my desktop (WeekMay2).  When I hit replace all, I get a dialogue box that says Update Values WeekMay2.xls, it's opening a folder I have on my desktop w/ the WeekMay2 file in it - I then have to select the open the WeekMay2 file for every replace I need to do.  There's around 28k of them, so doing this by hand isn't an option.

 

I've managed to work around this by only replacing the first cells across my row and then copying down, but I have to do this in multiple places and would prefer to find/replace across the entire worksheet.

@Bcurtis1 I am having a similar problem.  I am attempting to change all my cells from one reference sheet to another.  All I need to do is change the text in each formula from "mar" to "jun" in each cell and it will work.  I have done this in the past.  But excel is asking me to open a file?  Confused.


@Bcurtis1 wrote:

Using the find and replace function but a window pops up for EVERY replacement where I have to select the new file.  help!

 




 

@russell_riveraI may have found a sort of work around.  When opening the file I had the option to edit the links.  If I changed the links there, it worked faster.  And, once I got through this once it was ok going forward.  I've also found having the old file AND the new file open is helpful.

@Bcurtis1 Thanks for responding. I did find the source of my issue.  As it was saved in an '97-03 format.  I had to find a legacy copy of the file (in '16 format) and rebuild it (was just some copy and paste).  Thanks for your help.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies