ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Losing data on a shared workbook (https://www.excelbanter.com/excel-discussion-misc-queries/157081-losing-data-shared-workbook.html)

Martin September 5th 07 03:12 PM

Losing data on a shared workbook
 
I have a shared workbook that is being utilized by mupltiple users. It
appears that the data is not being saved across the board, all the time. I
have tried different things, setting automatic save and telling them to save
every five minutes, etc.....
I am running XP with SP2. More than enough memory. It is on a network
share.

Any thoughts as to why this is happening.

Gary''s Student September 5th 07 03:18 PM

Losing data on a shared workbook
 
Make sure there is a safety interlock that allows only one of the shared
users to have write access to the file at one time. Otherwise one user can
overwrite another user's work.
--
Gary''s Student - gsnu200742


"Martin" wrote:

I have a shared workbook that is being utilized by mupltiple users. It
appears that the data is not being saved across the board, all the time. I
have tried different things, setting automatic save and telling them to save
every five minutes, etc.....
I am running XP with SP2. More than enough memory. It is on a network
share.

Any thoughts as to why this is happening.


Martin September 5th 07 04:10 PM

Losing data on a shared workbook
 
Where can I find if this is turned on?

"Gary''s Student" wrote:

Make sure there is a safety interlock that allows only one of the shared
users to have write access to the file at one time. Otherwise one user can
overwrite another user's work.
--
Gary''s Student - gsnu200742


"Martin" wrote:

I have a shared workbook that is being utilized by mupltiple users. It
appears that the data is not being saved across the board, all the time. I
have tried different things, setting automatic save and telling them to save
every five minutes, etc.....
I am running XP with SP2. More than enough memory. It is on a network
share.

Any thoughts as to why this is happening.


Gary''s Student September 5th 07 08:24 PM

Losing data on a shared workbook
 
Have a user open the file.
Have a second also open the file while the first user still has it opened.
The second user should only be able to open it READ-ONLY
--
Gary''s Student - gsnu200742


"Martin" wrote:

Where can I find if this is turned on?

"Gary''s Student" wrote:

Make sure there is a safety interlock that allows only one of the shared
users to have write access to the file at one time. Otherwise one user can
overwrite another user's work.
--
Gary''s Student - gsnu200742


"Martin" wrote:

I have a shared workbook that is being utilized by mupltiple users. It
appears that the data is not being saved across the board, all the time. I
have tried different things, setting automatic save and telling them to save
every five minutes, etc.....
I am running XP with SP2. More than enough memory. It is on a network
share.

Any thoughts as to why this is happening.



All times are GMT +1. The time now is 09:59 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com