Excel 2007 - Shared Document

[cstimart]

I have a newly created document that is shared among several coworkers. Is there a way to prevent the elimination of entered data when multiple people add new data on the same line and try to save? (Macro Solution?)

When they save the document, the user is prompted to save retain their entries or retain the other user's entries...and the other data is lost.

I really feel that this should be an Access db, but people are scared of change.

Thanks!

 

[RoryA]

Nope. Shared workbooks are truly awful things and will blow up in your face at some point. I hope you have regular backups in place.
A database is definitely the way forward, even if you use an Excel front end for some reason.