I hear of occasions all the time where more than one person needs to work an a spreadsheet at the same time. Since Office 2003, Microsoft have included this functionality in Excel. To share a Workbook, simply follow the steps below:
- Office 2003: Tools - Share Workbook
- Office 2007: Review Tab - Share Workbook
Then click the “Allow changes by more than one user…” checkbox and save the document. Now a whole group of people can update the same document and see each other’s changes every time they press the Save button.
What’s your favourite Office tip?