Delete All Links to Worksheet
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.
|