X
xelement8
I have several questions concerning shared workbooks in
Excel XP and I am hoping that someone will be able to
assist me. The questions are below.
1. Concerning shared workbooks, what is the difference
between Save vs. Save As? How are multi-user edits
affected?
2. Why does User B receives an error message stating that
the shared workbook is locked by User A when User A is no
longer in the shared workbook. In addition, when the
share workbook dialog box is viewed, User A's name appears
twice in the "who has this workbook open now field".
3 Is it possible to lock content but still allow other
users filtering and sorting privileges?
Thanks
xelement8
Excel XP and I am hoping that someone will be able to
assist me. The questions are below.
1. Concerning shared workbooks, what is the difference
between Save vs. Save As? How are multi-user edits
affected?
2. Why does User B receives an error message stating that
the shared workbook is locked by User A when User A is no
longer in the shared workbook. In addition, when the
share workbook dialog box is viewed, User A's name appears
twice in the "who has this workbook open now field".
3 Is it possible to lock content but still allow other
users filtering and sorting privileges?
Thanks
xelement8