sharing workbook

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sharing workbook

Sharing workbook

resolvedResolved · Low Priority · Version 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:

Viewing Many Worksheets

If there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds.

View all Excel hints and tips


Server loaded in 0.13 secs.