I prepare reports that have VLOOKUP formulas that pull data from another
file. Each time I create a new report, I pull the data from a new file where
the only change is the date in the file name looking to.
First, it seems to work better if I do the "Ctrl ~" to show the formulas
first, then highlight the range of formulas I want to change.....then I did
the Find/Replace to change the date.
Lately it has not been working on "replace all" at all. Even with less than
1,000 formulas to change, when doing "replace all" it stops responding
completely. I have to do "replace" and sit there clicking enter for each
cell for it to work.
As a work around, I have changed the top formula and have been copying it
down on each row, which still takes forever.
What can I do to get the Find/Replace feature to work as it should?