Unable to 'Replace all'
 

Hi,

I am trying to replace the text in a number of forumlae in a worksheet.
When I try to use the 'replace all' tool, Excel pops up a window for me to
browse and select a file. The pop up window says 'Update Values: [filename].
I've never had this before- usually Excel just finds and replaces the text
with no pop up window.

Does anyone know why it is doing this and not simply finding and replacing
teh text as I want it to do...?!

Any help gratefully appreciated.

R

Unable to 'Replace all'
 

Whatever text you were replacing appears in the name of the worksheet.

If you have a formula that looks like:
=if(sheet1!e1="","",sheet1!e1)

And change all the E's to X's, your formula changes to:
=if(shXXt1!X1="","",shXXt1!X1)

And excel can't find a sheet with that name (shXXt1) in your workbook. So it's
asking you where is this sheet located--point to the file that contains a sheet
with that name.

So...

You have to be more careful with what you're replacing.



kippers wrote:

Hi,

I am trying to replace the text in a number of forumlae in a worksheet.
When I try to use the 'replace all' tool, Excel pops up a window for me to
browse and select a file. The pop up window says 'Update Values: [filename].
I've never had this before- usually Excel just finds and replaces the text
with no pop up window.

Does anyone know why it is doing this and not simply finding and replacing
teh text as I want it to do...?!

Any help gratefully appreciated.

R

--

Dave Peterson