Hi, I have a spreadsheet with a list of about 100 hyperlinks to files I use
and, because some of our folders have been moved and the folder names have
changed, the links now no longer work.

I have tried using edit/replace to change the links but that is only
changing the name of the hyperlink not the actual link itself. Does anyone
know of a way of changing the links for all of the files at all please?

All of the links have the same root for example

The files

U:\CommercialServices\book1
U:\CommercialServices\book2
U:\CommercialServices\book3
U:\CommercialServices\book4
U:\CommercialServices\book5

Are now all called

U:\ LCCG\Business Support & Services\Fin & ICT\Commercial Finance\book1
U:\ LCCG\Business Support & Services\Fin & ICT\Commercial Finance\book2
U:\ LCCG\Business Support & Services\Fin & ICT\Commercial Finance\book3
U:\ LCCG\Business Support & Services\Fin & ICT\Commercial Finance\book4
U:\ LCCG\Business Support & Services\Fin & ICT\Commercial Finance\book5