Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

sharing workbook

ResolvedVersion 2007

Julie has attended:
Excel Intermediate course

Sharing workbook

Please can one remind me of the steps to do in word to be able to share workbooks.

Many thanks.

RE: Sharing workbook

Hello Julie,

If you want to allow more than one person to edit a workbook at the same time, click the Review tab and then the Share Workbook icon in the Changes group. You can also simultaneously protect and share a workbook.

However, as you mention Word in your question, I assume we are talking about giving several people access to a Template that you all use.

The template must be saved on a Shared drive in a dedicated Templates Folder (the same location for all the different templates you need to share) and each person who requires access to them needs to go into Word, click the Office Button, click the Word Options button, select Advanced and then scroll to the bottom to click the File Locations... button. Select Workgroup Templates and click the Modify button to set the path to the correct drive and folder.

I hope this helps.

Kind regards,

Ruth

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.