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?