I have a problem.

I have an Excel 2003 workbook on a network that is constantly being accessed
by different people. It's a master copy that's supposed to have its changes
saved every time someone's done with it, but the problem is that it doesn't.
Someone goes in, makes their changes, saves, quits out, and then a few hours
later they come back and the changes haven't been saved. Strangely enough,
I've had people go back an hour later and the changes are there, but then a
little later, say in four hours, the changes are gone.

I've asked around and it seems like everybody who's been using the workbook
is having the same problem. It's very important that everyone's changes are
kept. Can anyone help out?

Thanks.

Is this a shared workbook?
if yes, then in a shared workbook when a user saves, he is asked 'Accept
min' or 'Accept others'. if he selects accept mine, the changes done by
others are not save.

I would suggest remove the share and make sure the workbook is used in
exclusive mode.
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Jill Valentine" wrote:

I have a problem.

I have an Excel 2003 workbook on a network that is constantly being accessed
by different people. It's a master copy that's supposed to have its changes
saved every time someone's done with it, but the problem is that it doesn't.
Someone goes in, makes their changes, saves, quits out, and then a few hours
later they come back and the changes haven't been saved. Strangely enough,
I've had people go back an hour later and the changes are there, but then a
little later, say in four hours, the changes are gone.

I've asked around and it seems like everybody who's been using the workbook
is having the same problem. It's very important that everyone's changes are
kept. Can anyone help out?

Thanks.