Excel Hyperlink Bug
Has anyone ever come across a problem whereby phantom hyperlinks get created in an Excel sheet?
ie Hyperlinks appear in cells that should not contain them (see screenshot).
This seems to occur after copying and pasting between Excel sessions.
This problem was observed on Excel 2002 here - perhaps this is known and fixed in future Excel versions?
http://excelexperts.com/sites/default/files/images/ExcelHyperlink_2.thum...
I tried that but it results
I tried that but it results in Excel hanging.
I also tried this:
Range("A1:IV1005").Hyperlinks.Delete
i.e. delete all at once rather than iterate through each one.
This also causes Excel to hang. This could be that the Excel spreadsheet is pretty large in the first place.
The phantom hyperlinks appear to occupy whole rows rather than specific cells.
Manually deleting a hyperlink in one row removes all hyperlinks in that row but strips out the formatting too which is weird. I can get round this by copying the formats to a blank sheet and copying the formats back once hyperlinks have been deleted.
hanging Excel
Excel hanging is normally due to calculation caused by the inclusion of volatile functions.
- try turning calculation to manual
Did have manual calc switched
Did have manual calc switched on but found that it was down to the "used range" being 256 columns wide.
Once the last few columns were deleted (down to 250 columns) I could remove all the hyperlinks in one go:
ActiveSheet.Hyperlinks.Delete
Thanks!
Hyperlinks.
Yep... Here's an ExcelExperts.com article on just that:
Remove Hyperlinks
Nick