ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,226
- Office Version
- 2007
- Platform
- Windows
Morning,
On my worksheet i have many invoices which in column P is there invoice number which is hyperlinked to a folder on my pc.
Today clicking on one of the hyperlinked numbers shows a message Unable to open hyperlink.
When i select edit hyperlink i see in the Address field something like the following.
../../../AppData/AppData/AppData/Roaming/Microsoft/DR%20COPY%20INVOICES/80.pdf
If i delete it & save it as a hyperlink again i now see the following.
DR%20COPY%20INVOICES/80.pdf
This works fine.
This is i have a couple of hundred to do.
Is there some code etc that will just show in the address field the part
DR%20COPY%20INVOICES/80.pdf
In this case the invoice is 80 but apart from that the rest of the cose is the same.
Otherwise im going to be here ages.
I dont see why they are even broken ???
Thanks
On my worksheet i have many invoices which in column P is there invoice number which is hyperlinked to a folder on my pc.
Today clicking on one of the hyperlinked numbers shows a message Unable to open hyperlink.
When i select edit hyperlink i see in the Address field something like the following.
../../../AppData/AppData/AppData/Roaming/Microsoft/DR%20COPY%20INVOICES/80.pdf
If i delete it & save it as a hyperlink again i now see the following.
DR%20COPY%20INVOICES/80.pdf
This works fine.
This is i have a couple of hundred to do.
Is there some code etc that will just show in the address field the part
DR%20COPY%20INVOICES/80.pdf
In this case the invoice is 80 but apart from that the rest of the cose is the same.
Otherwise im going to be here ages.
I dont see why they are even broken ???
Thanks