using find and replace it's making me look in another file to upd

  • Thread starter Thread starter jimmynfan
  • Start date Start date
J

jimmynfan

I have used the find and replace function several times in the spreadsheet to
update the fromulas monthly. For some reason when I use it this month it
wants me to look in another file to "update values"? There is not another
file and there is no way for me to use the find and replace.
 
Just a guess.

I bet that you're changing a string that appears in a formula that refers to
another workbook and by accident or coincidence, you're changing something
important to that formula.

For instance, if you had a formula like:
='C:\My Documents\excel\[book1.xls]Sheet1'!$A$1

And you also had a formula or string that looked like:
=text(k1,$#,##0.00") & " is due on the first of the month"

And you wanted to change all the k1's to K2, then the first string is gonna be
changed to:
='C:\My Documents\excel\[book2.xls]Sheet1'!$A$1
(book2 instead of book1)

And if you don't have a book2.xls, then excel is going to ask you where to find
this file.

So I think you have a couple of choices.
Change the string in your edit replace to remove that possibility:
I'd use:
xt(k1
to
xt(k2

Or be more selective in the range you choose to edit|replace. Avoid those cells
that could cause confusion.
 
Back
Top