Shared Worksheet Problem - Excel 2003

Question

I am in the process of creating an Excel 2003 spreadsheet for my job. The spreadsheet will be opened by 3-4 users at one time, & content will be added frequently. My question is, how am I able to use the same spreadsheet to do this. I know how to make a document "shared" and accessible to everyone, but my problem is; When someone fills in a cell, & saves it, someone else may have entered something into that cell & it asks which change to save. Am I able to have 3 or 4 people open the worksheet, place data in any cell, & once changes are saved, be placed into the next available row in a shared worksheet.

Any suggestions would be great.

Thanks in Advance

Answer 1

YOU CAN:

You need to check out this site.

http://www.badblue.com/helpxls.htm

I actually use edit grid which is free for me and I can create edit share and  do all of the functions that are in excel. the real time update feature is cool because I never have to save the worksheet and I can make daily/ hourly  copies by saving as just incase data gets corrupted i'm always only an hour behind.

Edit grid:

http://www.editgrid.com/site/learn/featu...

( THE BEST SHARING SOLUTION FOR SPREADSHEETS )

Try it out   and let me know

Answer 2

Excel 2007 has this capability. You tell it to share the workbook, and then multiple users can update it simultaneously. It gives you options on how to handle conflicting updates and such. I don't have Excel 2003 to compare, but if 2003 doesn't have this, maybe your best solution is to upgrade to 2007.

Answer 3

You can't, the first person to access it will be able to edit the document but everyone else will open it in read-only, I don't think you can get around this. You could have everyone write to their own spreadsheet and then make a vbscript that will pull the data to the main.