Rara,

The workbook share makes it possible for two or more users to have the
workbook open at the same time, and be able save their changes. The
operative part is "at the same time."

To allow opening by only certain users, use Password to open, or Password to
modify. This is in File - Save as. Click Tools - General Options. This
may be different on versions of Excel older than 2002, but it's still in the
Save as box. The password has nothing to do with the sharing.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Rara" wrote in message
...
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?