I recently downloaded a list of 3000 stocks symbols, prices and company descriptions from an internet site for offline analysis.
Unfortunately the list also contains a small thumbnail size chart which
covers many of the symbols when I load the material into Excel 2002.
The chart is in picture form not a specific hyperlink. However, if I click
on an individual chart from the spreadsheet I do connect to the internet
so there must be a hyperlink underneath.
I can remove the chart when I click and cut them one by one ---
however that would be quite time consuming with over 3000 to delete.
I have tried using a delete hyperlink macro but that didn't do the trick
either.
Is there any way to delete all of these hyperlinks in one operation.
Thanks.
Bookmarks