how to share?

[mithu81]

hello question for you guys on the best way to share and collaborate excel spreadsheets..

each week i have to send a spreadsheet to 18 people.. they make updates to their specific section and email back to me. then i copy and paste all their responses into one sheet and submit that to my boss.. its very time consuming and outdated method of collaboration.

i created a web part on a sharepoint site (sharepoint 2003), but am having some troubles due to multiple people saving their info on the webpart at the same time. this is causing some people data not to be saved.

i created a sharepoint list which worked great becasue it acts like a database file. everyone can access it and make changes.. as long as they do not update the same cell it works fine. only problem is that i can not add color to the spreadsheet and can not use some excel features like sort and other cosmetic spreadsheet features.

anyone have any suggestions how i can share a spreadsheet with multiple people and get updated results quickly? what would the best practice for something like this be?

Thanks again for you help.

 

[Stormseed]

Did you try the "Share Workbook" option under Tools menu?

 

[mithu81]

yea.. but the problem is i do not have a network drive where i can put the file for everyone to access. all i have is the sharepoint and email. and educating the sales team on checking in/out a file on the sharepoint will work but will take way to long.

 

[Stormseed]

Are you on a local network?

If yes, you just need to map a drive on your local network. If not then I do not know the solution to your problem.