I have a main worksheet with many links to another worksheet tab. That other
secondary worksheet contains data that will now be collected differently (not
in my files), and I want to delete all of my links in the main sheet that
reference that sheet. I tried a search-replace using a wildcard to refer to
any cells in that 'old' worksheet and then 'blank' for the replace with field

find: Acme Data usd*
replace with:

but I get an error message indicating 'That Name Is Not Valid.'

Hope you can assist. Thank you.

I think I just answered my own question...the cells in my main sheet have are
formulas and so I simply did this instead:


find: 'Acme Data usd+*
replace with: +

....and it seems to work. Sorry I didn't figure that out sooner!

"Mary" wrote:

I have a main worksheet with many links to another worksheet tab. That other
secondary worksheet contains data that will now be collected differently (not
in my files), and I want to delete all of my links in the main sheet that
reference that sheet. I tried a search-replace using a wildcard to refer to
any cells in that 'old' worksheet and then 'blank' for the replace with field

find: Acme Data usd*
replace with:

but I get an error message indicating 'That Name Is Not Valid.'

Hope you can assist. Thank you.