How do I convert a link to a value on a worksheet basis. I have other sheets
that I want to keep the links on for the time being. As I understand the
"break links" option beaks the whole workbook.

Mike