I have over 200 employees who use a time sheet designed in excel. On every
computer their is an additional excel file at the root of C:. Every one's
individual time sheet references that "functions" file at the root of C:
(Since we e-mail the time sheets to supervisors for electronic signatures, we
wanted to make the file as small as possible so the bulk of the programming
is in the "functions" file at the root of everyone's C:).

When an employee sends his/her time sheet to his supervisor via e-mail, the
supervisor opens it and the file looks for it's reference file at the root of
C: and finds it (as it is on everyone's computer).

This has worked like a charm for several years.

Some staff are getting new computers and their time sheet file works fine on
their own computer. However, when they send their time sheet via e-mail to
their supervisor, when the supervisor open's it, it has lost the mapping to
the reference file????? Why and what can be done?


--
Thanks
Shawn