Thread
:
Edit-Links Option not available
View Single Post
#
2
Posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
Posts: 35,218
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
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson