View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
macropod
 
Posts: n/a
Default Replace Function

Hi Autumn Dreams,

This sounds like you're changing a formula that links to an external file
named "Update Values -06" and Excel can't find "Update Values -07" in the
same folder. Does "Update Values -07"? In the same folder? If the answer in
no to either of these, that's why you're getting the prompt.

Cheers

--
macropod
[MVP - Microsoft Word]


"Autumn Dreams" wrote in message
...
When I use the Replace function to replace -06 with -07 (changing the year

in
each formula) and click Replace All, a window comes up "Update Values -06"
and opens into My Documents. To get rid of it you have to click cancel

for
each formula highlighted and that would entail 240 times. How do I get

past
this?