Sharing an Excel Workbook - Help!

A

alexm999

I put my excel file on my server. I made the file 'shared'. When
person is useing it, the other person who opens the file gets a Locke
error message.
Can anyone help?

I thought if the file is shared, then multiple people can access it an
make changes...

?
 
G

Gilles Desjardins

No, not at the same time. If you want that functionality it is better to use
a database program such as Access.
When you share a file the second person gets a copy and does not see what
the first person is doing. The second person will not know about the changes
until the first person exits, the second person exits and the second person
re-opens the file.

HTH

Gilles
 
Top