I have an excel sheet that has hyperlinks to other sheets. All sheets are on
a network share and permissoins are open to all.
When I attach and email the excel sheet (that contains the hyperlinks) from
the network share, the recipient receives the sheet and opens it, the
hyperlinks have all been changed and now point to the recipients C drive
Documents and Settings instead of the network share, hence not being able to
open the hyperlink.
If I copy that sheet from the network share and paste it to my desktop and
then attach and email it, everything works great.
Any ideas??? I tried this on both Excel 2000 and 2003. Thanks.