Results 1 to 5 of 5

Thread: Need your help... fast!

  1. #1
    Join Date
    May 2003

    Need your help... fast!

    Can anyone please explain how is it possible to have a file from a shared drive open at two different systems at the same time. One system is NTsp6 and the other one is win2k sp1. The file is on the shared drive S: Under the premissions of the file it seems that "Everyone" has full access to the file. I can even take "Ownership" of the file. Everyone can open the file and save at the same time which will create problems. It is an Excel sheet therefore you can set the sharing premissions on the file from "tools" - "share workbook". When you click on this menu selection. You can see that "allow more than one user to make changes at the same time" is check BUT it's faded and there's no way of unchecking it... CAN ANYONE HELP. Who can uncheck it. I everyone can take the "ownership" but noone can unchek it... It's very important file .. help

  2. #2
    Join Date
    Jul 2002
    What version of excel are you using??

    We have had some of the same issues with W2K and Excel 97.

    Also could be your virus scanner.

    Just some thoughts


  3. #3
    Join Date
    Jun 2003
    Copy it then paste it on your personal(safe) drive and then delete it from the S: drive. Can you do this?
    \"The feeling of losing your mind is a terrible thing. But once it\'s gone, you\'re fine.\"
    Carrie Fisher

  4. #4
    Master-Jedi-Pimps0r & Moderator thehorse13's Avatar
    Join Date
    Dec 2002
    Washington D.C. area
    By default, you are able to edit this section. In my opinion, one of two things are in play here.

    1) Until everyone closes the worksheet, you cannot edit this feature. Try to boot everyone from the file then see if this opens the option.

    2) Someone has added security to the workbook. If this is the case then find out who. I can't tell ya here how to bust up Excel worksheets but it can be done using both commercial and ummm, other software. Google is your friend

    Hope this helps.
    Our scars have the power to remind us that our past was real. -- Hannibal Lecter.
    Talent is God given. Be humble. Fame is man-given. Be grateful. Conceit is self-given. Be careful. -- John Wooden

  5. #5
    Join Date
    May 2003
    Thank you...Thank you...

    You're right of course horse; It was (as usuall) simplest and the most obvious answear.
    Everyone has to close the file and then we can change the thinggy... I cannot believe that
    no one here thought of that one...

Posting Permissions

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