Personally I have always had luck with removing any hyperlinks by selecting all of the cells with hyperlinks in them. Copy the range. Then paste special. Select multiply and paste it. This has always removed all hyperlinks for me and it's very quick to do.