View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Shared workbook loses data

1. person A opens the workbook
2. person B opens the workbook
3. person B saves & closes the workbook with his/her changes
4. person A saves & closes the workbook erasing person B's changes
--
Gary''s Student - gsnu200740


"Chuck W" wrote:

I have a shared workbook that is stored on a network, and is used by about 30
people. Each user has their own section of the workbook that they enter data
into. This workbook also has a before close macro that saves the file
everytime it is closed.

Every now and then, someone will enter data into the sheet, and when the
file is reopened the data will be gone. Does anyone have any idea why this
is happening and if anything can be done to prevent it?

Any help would be greatly appreciated.