Problem with Shared Worksheet in Excel 2003

Mtwalther · 08-06-2008, 01:01 PM

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.

I am not all that knowledgeable with Macros or VB, but do have some Java experience. As simple as possible would be appreciated.

Any suggestions would be great.

Thanks in Advance

darrensmith016 · 08-06-2008, 01:05 PM

i think access would probaly be a better option for multi user

08-06-2008, 01:01 PM	#1 (permalink)
Mtwalther Registered User Join Date: Aug 2008 Posts: 1 OS: XP, Ubuntu, Leopard	Problem with Shared Worksheet in Excel 2003 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. I am not all that knowledgeable with Macros or VB, but do have some Java experience. As simple as possible would be appreciated. Any suggestions would be great. Thanks in Advance

08-06-2008, 01:05 PM	#2 (permalink)
darrensmith016 Registered User Join Date: Aug 2008 Location: Nottingham Posts: 149 OS: Dos, 3.11, Win95, 98, 2000 + Server, XP Home and Pro, Vista and Server 2003 SP2 and 2008 My System	Re: Problem with Shared Worksheet in Excel 2003 i think access would probaly be a better option for multi user