Sharing an Excel Workbook - Help!

  • Thread starter Thread starter alexm999
  • Start date Start date
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...

?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

corrupted shared excel workbook 1
Sharing workbooks limitations - Merged Cells 12
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Shared Workbook Locked 2
Email Excel Workbook Automatically Daily 3
Locking cells in a shared workbook 2
Shared workbooks 2
VB Code to Share Workbook 2

Back
Top