I have a spreadsheet that is used to maintain stock in a warehouse. As below:
Column A had hyperlinks in it that linked to folders and excel spreedsheets on a NAS storage drive.
However since a computer update the links have changed. As you can see in the image below I have highlighted one of the cells so you can see the new hyperlink. It has added ".....\AppData\Roaming\....." This never used to be there, and as far as I can see doesn't even exist.
How can I get these links back to being correct?
As an example, the location of the link that is highlighted in the image above should be as follows:
\NAS00E421\Warehouse\Master Product Files\Aisle 1A\Product File 019A09C.
There are too many lines to be doing this manually, I assume a VBA should be able to fix this, but my VBA knowledge is very limited
Thanks for the help in advance
Column A had hyperlinks in it that linked to folders and excel spreedsheets on a NAS storage drive.
However since a computer update the links have changed. As you can see in the image below I have highlighted one of the cells so you can see the new hyperlink. It has added ".....\AppData\Roaming\....." This never used to be there, and as far as I can see doesn't even exist.
How can I get these links back to being correct?
As an example, the location of the link that is highlighted in the image above should be as follows:
\NAS00E421\Warehouse\Master Product Files\Aisle 1A\Product File 019A09C.
There are too many lines to be doing this manually, I assume a VBA should be able to fix this, but my VBA knowledge is very limited
Thanks for the help in advance
