+ Reply to Thread
Results 1 to 3 of 3

excel no copy, users must use origonal

  1. #1
    Registered User
    Join Date
    02-22-2008
    Posts
    2

    excel no copy, users must use origonal

    I have looked at some threads on preventing copies of excel files and all the help concentrates on high caliber protection. What I am looking for is, in a network, all users can edit the spreadsheet and save it, but only one copy ever exists.
    My problem arises when a user creates a copy, usually inadervtantly when in READ ONLY mode and saves changes and then continues to use the copy which is not updated and therefore invalid.
    This is not a security issue, it is simply to insure that all users are acessing up-to-date info.
    In essence if the sheet is updated then saved, that is OK but if the user is in read only mode and attempts a save, excel will invite a new copy which I want to prevent. I only want one copy on the server and no copies in various MY DOCUMENTS.
    My apologies for being long winded but most threads I read are an exersise in missunderstanding and I don,t need to keep out hackers. I just need one shared copy.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    read only means just that. what is happening is the user is downloading a copy to their local drive and editing that.
    this is not ever going to work.
    use ;tools/share workbook
    in advanced make sure the 'ask me which changes win is selected.'
    then say a1 was edited by another user .it will tell them!
    they must then select accept other users changes or it will prompt them to save a copy!

  3. #3
    Registered User
    Join Date
    02-22-2008
    Posts
    2

    Smile

    makes sense, thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1