Lost Reference

[Guest]

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?

 

[Doug Glancy]

Shawn,

I can't be much help, hopefully somebody else can, but I'm guessing the new
machines have Windows Vista and what you're seeing is a result of its
heightened security settings. I tried googling "accessing c drive vista"
and saw some stuff that might be helpful.

Doug

 

[Guest]

They are running XP 5.1
--
Thanks
Shawn

Shawn,

I can't be much help, hopefully somebody else can, but I'm guessing the new
machines have Windows Vista and what you're seeing is a result of its
heightened security settings. I tried googling "accessing c drive vista"
and saw some stuff that might be helpful.

Doug

 

[Jim Rech]

What does Edit, Links show on the supervisor's machine for that link? Worse
case, I think the supervisor should be able to re-establish the link using
the Change Source button on that dialog. In fact a macro may be able to do
that automatically (assuming you don't figure out what's different on the
new machines).

--
Jim
| They are running XP 5.1
| --
| Thanks
| Shawn
|
|
| "Doug Glancy" wrote:
|
| > Shawn,
| >
| > I can't be much help, hopefully somebody else can, but I'm guessing the
new
| > machines have Windows Vista and what you're seeing is a result of its
| > heightened security settings. I tried googling "accessing c drive
vista"
| > and saw some stuff that might be helpful.
| >
| > Doug
| >
| > | > >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
| >
| >
| >

 

[Guest]

When I hit edit and look for links it is blanked out. These aren't links but
two files that reference one another???