Okay,

I have a two worksheet .htm spreadsheet.

The first sheet hyperlinks by =hyperlink to the second sheet where the
location is determined by the =cell("filename") function and a
concatenated filename.

When I copy the .htm to another location, the =cell("filename") updates
to the new location, but strangely the =hyperlink remains as the old
path.

How do I ensure that it is updated when the htm file is copied to a new
location?


--
ColB
------------------------------------------------------------------------
ColB's Profile: http://www.excelforum.com/member.php...o&userid=36350
View this thread: http://www.excelforum.com/showthread...hreadid=571353