Forum Discussion

Bcurtis1's avatar
Bcurtis1
Copper Contributor
Jun 07, 2019

find and replace

Using the find and replace function but a window pops up for EVERY replacement where I have to select the new file.  help!  
excel
russell_rivera's avatar
russell_rivera
Copper Contributor
Jul 03, 2019

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!

 

 

  • Bcurtis1's avatar
    Bcurtis1
    Copper Contributor
    Jul 03, 2019

    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.

    • russell_rivera's avatar
      russell_rivera
      Copper Contributor
      Jul 03, 2019

      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.