Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 5th 07, 03:12 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 336
Default 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.

  #2   Report Post  
Old September 5th 07, 03:18 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default 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.

  #3   Report Post  
Old September 5th 07, 04:10 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 336
Default 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.

  #4   Report Post  
Old September 5th 07, 08:24 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shared workbook loses data Chuck W[_2_] Excel Discussion (Misc queries) 6 September 12th 07 03:24 PM
Data Entry in shared workbook RUSH2CROCHET Excel Discussion (Misc queries) 0 August 28th 07 09:50 PM
copy workbook files without losing data that was in the org. work rue Excel Worksheet Functions 0 October 24th 06 09:57 PM
Problems losing changes in shared workbook ACraig Excel Worksheet Functions 0 November 16th 05 03:02 PM
Shared workbook losing print settings koppers Excel Discussion (Misc queries) 0 November 11th 05 01:09 AM


All times are GMT +1. The time now is 02:58 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017