Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2006

Tip: Looking for answers? Try searching our database.

Accept or reject changes in shared files

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jim Normile - 20 Oct 2006 20:45 GMT
I have a shared file on a server drive which is shared by a work group of
five users.
I can see the hchanges highlighted for the different users, and I can accept
or reject.
The problem is that so can all the users.!!
I need exclusive ability, as the "Master" of the situation, to acccept or
reject changes. I do not want the rest of the group to have this ability.
What am I doing wrong??
Thanks for any advice
Jim Normile
Earl Kiosterud - 20 Oct 2006 21:58 GMT
Jim,

When a workbook is shared, it means more than one person can open it for
update.  This is normally disallowed in a multi-user environment.  They both
start with the same copy, and each makes his own edits.  When there's a
conflict, it's between one user who has saved the workbook, and another who
is attempting a save.  The conflict relates to cell(s) that have been
changed by both users.  Remember that they both opened the same original
workbook.  Sharing doesn't give one "master" person control over this.  It
lets each user decide whether to allow his changes to prevail, or the
earlier user who's already saved the workbook.

Signature

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

>I have a shared file on a server drive which is shared by a work group of
> five users.
[quoted text clipped - 7 lines]
> Thanks for any advice
> Jim Normile
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.