@Markus_Richert
Without using VBA, no, there's no way to do this.
How to change multiple hyperlink paths at once in Excel?
or make at own the steps...here the instructions
- Make a backup copy of the file
- Right click on the table tab
- show code
- Paste this code:
Private Sub Test()
Dim H A's hyperlink
For Each H In Me.Hyperlinks
H.Address = Replace(H.Address, "\Intern\falli\", "\Intern\EXPORT_IMPORT\falli\")
Next
end sub
- Click anywhere in the sub with the cursor
- Press F5 (you can't see anything, the mouse pointer may turn into an hourglass, wait)
- VBA editor too
- Save file
Hope I was able to help you with this info.
NikolinoDE
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful!
This will help all forum participants.
