Posted: 1/4/2010 6:01:43 PM EDT
|
setting this up for a short duration so some people can all work on the same spreadsheet w/out all saving/emailing it to each other so i opted to put up a trial of win2k8server w/ a copy of excel 2k7 on it. i have the admin acct and then 1 user acct for 3 people to use - again, this is extreme short time so they can get this done within the next month or 2. problem is, is when i have terminal services set to "allow only 1 connection per user", the user that is on gets booted whenever somebody else logs on. i could fix this by allowing multiple user connections, or give each a username/pass and all access to the file, but then when somebody is using the file, it gets opened in read only mode and this may cause a problem if somebody doesn't "get it" - these are not computer people. why would, if i have 3 people using the same username, the first connection get kicked in favor of the 2nd? this to me makes no sense, imho, the 2nd user should get a message saying that the username is currently in use. did i miss something in the setup??? please assist again, i know this is not the correct way to do things, but they just need to get this data done quickly and i thought this would be the fastest way.... |
|
You will need to setup Microsoft Office SharePoint Server. http://office.microsoft.com/en-us/excel/HA100898961033.aspx ETA: You might want to look into using Google Spreadsheets. I believe it has online collaboration tools built-in that allow mulitple users to access and edit the same spreadsheet simultaneously. |
d/l the setup now, thanks  will probably set it up to check it out, if not maybe i will just allow multiple connections and tell them if a window pops up to hit cancel. really didn't want to use google, just wanted to keep the data personal as it is semi-sensitive. |
|
Windows Server allows 2 concurrent RDP connections in administrative mode. If you want to have more, you will have to license each user and change the server to CAL mode where each user has a client license. Regardless of administrative or CAL mode, whenever an instance of Excel opens a file for editting, it will lock it so others may only read it.
As suggested, your best bet is Sharepoint - MOSS or SPS. You still cannot have multiple users actively saving to a single document file, but you have versioning control so that users are aware that someone is actively working on a document and can merge changes smartly without colliding. |