Select the area which contains unwanted hyperlinks and run this macro:

Sub RemoveHyperlinks()
Selection.Hyperlinks.Delete
End Sub

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup