Victoria has attended:
Excel Intermediate course
Excel Advanced course
Sharing Workbooks
Dear Best Training,
Please could you tell me if it is possible to share a workbook and have two users using the same document at the same time?
I have two colleagues currently investigating the help options but they have not found the answer they are looking for.
Thank you very much!
Vicky
RE: Sharing Workbooks
Hi Victoria
Thank you for your question.
There is a Share Workbook option in Excel which you can use so that more than one person can edit the same workbook at once.
In Excel 2003, go to Tools - Share Workbook.
On the Editing tab, tick the Allow changes by more than one user at the same time box.
On the Advanced tab, set up further options to control change tracking, history and conflicts.
Then click OK.
I hope this helps.
Amanda
