This is an interesting subject. I have a sheet that is shared by about 6
people in the office.
I want to give one person the right to change the content any cell and the
others only specific cells. I also want to keep track of who changed a cell
and when. At the end of the day I want see who changed what (including the
privelidged user). I'm getting confused with the protection and sharing
features. Is it so that the priv. user should bump off the others when she
changes cells? Will the tracking of the changes by other users stay logged
somewhere when the file is saved? How should I (or should I) set the "Track
changes" feature? (we have a p2p network so no domians but workgroups)

"CyberTaz" wrote:

You are most welcome, glad it helped. Earl's reply is right on track with the
second issue, or you might want to work through your network admin to set up
access rights.|:)

"Rara" wrote:

First of all, thank you for your help. Now, my 2nd question is, is there a
way to restrict sharing of files to, let's say, just 3 people in the office?
So that those people can view/edit the file and the others won't have access
to it. Did that make sense? :D

"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?