See this page
http://www.rondebruin.nl/values.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"doublew" wrote in message ...
Hi I'm using Excel 2003. I have a workbook with multiple sheets. Some
sheets contain links to one other sheet within the same workbook. I want to
remove all the links to this particular sheet and replace with values so that
I can delete the sheet. I can do this using Paste Special-Values, but this
takes time as has to be done individually for each link (they are not nicely
aligned in one column).

Is there a quick way to remove these links? I have seen many comments
referring to the Edit-Links menu option, but when I go to the Edit menu, the
Links option is greyed out - why is this? Does it only work for external
links?