excel multiple users

[Sharid]

Is there a way of making excel accessible to multiple users at the same time so they can all go into it and input date, save the same file regardless if someone is already using it and not override the other users work. Kind of like an access data base.

I sure the answer is NO and this is what I have advised my employer, but he seem to think it wont be an issue.

 

[iliace]

Under Tools, select Share Workbook. Or, in Excel 2007, this is under the Reviewing tab. Make sure you read up on the subject; here are some links:

http://office.microsoft.com/en-us/excel/HA010130571033.aspx
http://office.microsoft.com/en-us/excel/HP052622941033.aspx
http://www.exceladvisor.net/sub/creative/sharing.htm

You may also want to consider using Windows Live workspaces for this.

https://accountservices.passport.net/reg.srf?bk=1213300212