is it possible to set modify privilege for different user?
for example, use A can only modify the sheet1, other sheets ready only, user
B can only be allowed to modify/edit sheet2, rest sheets read only.


"CyberTaz" wrote:

I'm not clear on your question, because in order for more than one user to
work in the file at the same time, it MUST be Shared. The file does not need
to be stored in the Shared Documents folder (if that's what you're referring
to) as long as it is stored in a folder each user has access to.

Using Excel's ToolsShare Workbook feature when one user saves changes any
changes saved by another user are indicated and vice-versa.

Am I on the right track? |:)

"Rara" wrote:

Is there a function in excel that lets 2 or more people work at the same time
on a file (not in the shared documents) and reflect the changes?