I have a fairly simple database containing one column of hyperlinks and a few other columns of other data (some text, some numeric).
I'm using Excel 2000's advanced filter to copy selected rows to another location. The extract works fine, and cells that were hyperlinks in the original database appear with the format of hyperlinks (blue, underlined text). They *look* like hyperlinks...
Unfortunately, they're just blue underlined text - they no longer work as hyperlinks. Is it possible to make the advanced filter copy the cells as working hyperlinks?
Many thanks,
Ian
I'm using Excel 2000's advanced filter to copy selected rows to another location. The extract works fine, and cells that were hyperlinks in the original database appear with the format of hyperlinks (blue, underlined text). They *look* like hyperlinks...
Unfortunately, they're just blue underlined text - they no longer work as hyperlinks. Is it possible to make the advanced filter copy the cells as working hyperlinks?
Many thanks,
Ian