June 17th, 2003, 06:41 PM
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
June 17th, 2003, 06:47 PM
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
June 17th, 2003, 06:49 PM
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.\"
June 17th, 2003, 06:54 PM
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
June 17th, 2003, 07:29 PM
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...