Hi Roxi-

I'm afraid that is just the opposite of what a Shared Workbook is all about.

If each user needs to maintain separate data they might use the shared file
as a model & then Save As... once they open it.

Are you sure a template isn't what you're after?

HTH |:)

"Roxi" wrote:

Is there a way to have muti users entering data at the same time in the same
shared workbook and have excel save all changes? The data is different for
each user and involves adding new rows of data.