Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks for your response.
If that is the case then what is the purpose of even having a shared workbook? I'm surprised at just how little information I've been able to find about exactly how a shared workbook works. I really wish I had used a database!!! "Gary''s Student" wrote: 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. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Info here,
http://office.microsoft.com/en-us/ex...968331033.aspx Chuck W wrote: Thanks for your response. If that is the case then what is the purpose of even having a shared workbook? I'm surprised at just how little information I've been able to find about exactly how a shared workbook works. I really wish I had used a database!!! "Gary''s Student" wrote: 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. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks for the response, but I'm using excel 2003. I still have only been
able to find one site on the entire internet that vaguely explains the actual process behind saving a shared workbook. Gary's Student wrote: 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 I just can't believe it is that easy for data to be lost. If anybody can add anything to this, please do. "Bob I" wrote: Info here, http://office.microsoft.com/en-us/ex...968331033.aspx Chuck W wrote: Thanks for your response. If that is the case then what is the purpose of even having a shared workbook? I'm surprised at just how little information I've been able to find about exactly how a shared workbook works. I really wish I had used a database!!! "Gary''s Student" wrote: 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. |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Have you read this one then?
http://office.microsoft.com/en-us/ex...CH010003631033 Chuck W wrote: Thanks for the response, but I'm using excel 2003. I still have only been able to find one site on the entire internet that vaguely explains the actual process behind saving a shared workbook. Gary's Student wrote: 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 I just can't believe it is that easy for data to be lost. If anybody can add anything to this, please do. "Bob I" wrote: Info here, http://office.microsoft.com/en-us/ex...968331033.aspx Chuck W wrote: Thanks for your response. If that is the case then what is the purpose of even having a shared workbook? I'm surprised at just how little information I've been able to find about exactly how a shared workbook works. I really wish I had used a database!!! "Gary''s Student" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Lost While Using a Shared Workbook | Excel Worksheet Functions | |||
Data Entry in a Shared Workbook | Excel Worksheet Functions | |||
Updated data not appearing in shared workbook. | Excel Discussion (Misc queries) | |||
Why do I lose data in a shared workbook? | Excel Discussion (Misc queries) | |||
Shared workbook does not display data... | Excel Discussion (Misc queries) |