06-07-2019 01:18 PM
06-11-2019 11:26 AM
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.
07-03-2019 09:10 AM
@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.
Using the find and replace function but a window pops up for EVERY replacement where I have to select the new file. help!
07-03-2019 09:27 AM
@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.