C
ColB
Okay,
I have a two worksheet .htm spreadsheet.
The first sheet hyperlinks by =hyperlink to the second sheet where th
location is determined by the =cell("filename") function and
concatenated filename.
When I copy the .htm to another location, the =cell("filename") update
to the new location, but strangely the =hyperlink remains as the ol
path.
How do I ensure that it is updated when the htm file is copied to a ne
location
I have a two worksheet .htm spreadsheet.
The first sheet hyperlinks by =hyperlink to the second sheet where th
location is determined by the =cell("filename") function and
concatenated filename.
When I copy the .htm to another location, the =cell("filename") update
to the new location, but strangely the =hyperlink remains as the ol
path.
How do I ensure that it is updated when the htm file is copied to a ne
location