Excel 2000 hyperlinks (2000 Sr2)

Topic

New Reply

Hi all:

Our illustrious IT dept switched servers over the weekend. I have a client that had some hyperlinks in an Excel spreadsheet. They no longer work. The old path was ps109asr1…..; The new path should be qwars214megagis_filesS-DWGS_2004….

What got changed was ps109asr1 to qwars214mega. The sub-paths did not get appended to the new path. Is there any way to update the new hyperlink to the correct path (short of doing each one individually). TIA

Reply | Quote

Replies

See the thread starting at post 211304, in particular Pieterse‘s reply post 211636.

Reply | Quote

Hans: I tried Pieterse’s post but to no avail. I have attached the spreadsheet with macros. Thanks again.

Reply | Quote

It works OK for me in Excel 2002 SP-3. Note that there are different paths in the hyperlinks: ps109asr1… and ps109fsr1…
You will have to run the macro for each path separately.

Reply | Quote

I am running Excel 2000 SP3, after upgrading from SR-1. Still no results. I was aware of the different paths, but thanks.

Reply | Quote