View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Edit-Links Option not available

Edit|Links is used with external links--links to different workbooks--not
different worksheets within the same workbook.

Maybe you could do some edit|Finds and look for the worksheet name in formulas.
You may find a few false positives if the worksheet name isn't unique, though.

wrote:

I have a workbook in which many sheets contain links to one particular
sheet. I now want to remove those links quickly and delete that
sheet.

When I go to the Edit menu however, the Links... option is greyed out
and I can't click it. Any idea why this is? I don't want to use the
Copy Paste Special Values method to remove the links as this takes
too much time.


--

Dave Peterson