Mysterious Hyperlink Issue

[purceld2]

Hi all

I have an issue that is baffling me it's concerning me exported from an application called TreeSize a list of all the items on my desktop (C: Drive).
The app exports them in excel spreadsheet format with Hyperlinks to the items on the desktop. I then open the spreadsheet to import it into another spreadsheet which resides on my H: drive.

All goes fine but when but when I try to open one of the the hyperlinks if has changed the links location from the C: drive to the H: Drive and give an error as there is such location (see attached image)

When the spreadsheet is export from TreeSize the hyperlink works fine but as soon as I copy it into another workbook it changes the hyperlink location.

Could somebody explain to me what is happening and how I can get around it please.

Desmond-Dell_C_Desktop 2.xlsx
	A	B	C	D	E	F	G	H	I	J
1	TreeSize Report, 05/12/2022 13:11
2	C:\Users\desmo\Desktop\
3	Drive: C:\ Size: 231.8 GB Used: 161.7 GB Free: 70.2 GB
4
5	Name	Full Path	Size	Allocated	Files	Folders	% of Parent (Allocated)	Last Modified	Last Accessed	Owner
6	1985 - Greatest Man book - Original Watchtower Articles up to story 52.pdf	C:\Users\desmo\Desktop\1985 - Greatest Man book - Original Watchtower Articles up to story 52.pdf	108.6 MB	108.6 MB	1	0	48.3%	05/10/2014	24/09/2022	desmo
7	Greatest Man	C:\Users\desmo\Desktop\Greatest Man\	108.6 MB	108.6 MB	3	0	48.3%	15/04/2022	24/09/2022	desmo
8	WaveLab Elements 10 Manual.pdf	C:\Users\desmo\Desktop\WaveLab Elements 10 Manual.pdf	5.1 MB	5.1 MB	1	0	2.3%	11/05/2021	24/09/2022	desmo
9	2009-Field-Service-Research-Book.pdf	C:\Users\desmo\Desktop\2009-Field-Service-Research-Book.pdf	1.6 MB	1.6 MB	1	0	0.7%	05/10/2014	24/09/2022	desmo
10	eXtended Make Directory.pdf	C:\Users\desmo\Desktop\eXtended Make Directory.pdf	346.5 KB	348.0 KB	1	0	0.2%	01/01/2022	24/09/2022	desmo
11	Dragon User Guide 15.pdf	C:\Users\desmo\Desktop\Dragon User Guide 15.pdf	264.4 KB	268.0 KB	1	0	0.1%	15/04/2020	24/09/2022	desmo
12	µTorrent.lnk	C:\Users\desmo\Desktop\µTorrent.lnk	938 Bytes	4.0 KB	1	0	0.0%	24/11/2020	24/09/2022	Administrators
13	Advanced Renamer.lnk	C:\Users\desmo\Desktop\Advanced Renamer.lnk	845 Bytes	4.0 KB	1	0	0.0%	21/09/2021	24/09/2022	Administrators
14	AHK RareTheGui.lnk	C:\Users\desmo\Desktop\AHK RareTheGui.lnk	1.1 KB	4.0 KB	1	0	0.0%	27/09/2021	24/09/2022	desmo
15	Amazon Alexa.lnk	C:\Users\desmo\Desktop\Amazon Alexa.lnk	3.1 KB	4.0 KB	1	0	0.0%	13/12/2020	24/09/2022	desmo
16	AmoK Playlist Copy.lnk	C:\Users\desmo\Desktop\AmoK Playlist Copy.lnk	2.1 KB	4.0 KB	1	0	0.0%	30/11/2020	24/09/2022	Administrators
17	AutoHotkey.lnk	C:\Users\desmo\Desktop\AutoHotkey.lnk	2.6 KB	4.0 KB	1	0	0.0%	13/12/2020	24/09/2022	desmo
18	Automate Enterprise 11 Management Console.lnk	C:\Users\desmo\Desktop\Automate Enterprise 11 Management Console.lnk	1.9 KB	4.0 KB	1	0	0.0%	04/11/2022	04/11/2022	desmo
19	beaTunes5.lnk	C:\Users\desmo\Desktop\beaTunes5.lnk	1.7 KB	4.0 KB	1	0	0.0%	23/12/2021	24/09/2022	desmo
20	Capture2Text.exe.lnk	C:\Users\desmo\Desktop\Capture2Text.exe.lnk	1.0 KB	4.0 KB	1	0	0.0%	15/11/2022	15/11/2022	desmo
Details 2022-12-05_13-11-16

Regards

Desmond

 

[Jeffrey Mahoney]

Excel Hyperlinks suck. They change on me all the time. I don't create hyperlinks directly from the data in the cell. Store the actual link (full path and file name) in a different cell and use the HYPERLINK function to reference it.

Book7
	L	M
10	Report Analysis	Q:\IC&SC\6.Central Team\2. Report Working Files\Project Register\RptAnalysis - CurrentWorkingFile.xlsm
Sheet1

Cell Formulas
Range	Formula
L10	L10	=HYPERLINK(M10,"Report Analysis")

 

[purceld2]

Excel Hyperlinks suck. They change on me all the time. I don't create hyperlinks directly from the data in the cell. Store the actual link (full path and file name) in a different cell and use the HYPERLINK function to reference it.

Book7
	L	M
10	Report Analysis	Q:\IC&SC\6.Central Team\2. Report Working Files\Project Register\RptAnalysis - CurrentWorkingFile.xlsm
Sheet1

Cell Formulas
Range	Formula
L10	L10	=HYPERLINK(M10,"Report Analysis")

Hi Jeffrey,
Thanks for your reply.
I will take you advice in future.
Much appreciated.
Regards
Desmond