sharing workbook
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Sharing workbook

resolvedResolved · Low Priority · Version 2007

replyReply Wed 7 Sep 2011, 17:00Delegate Julie said...

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.

For upcoming training course dates see: Pricing & availability

replyReply Fri 9 Sep 2011, 16:18Trainer Ruth said...

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

 

Please browse our web site to find out more about
excel training microsoft and other Microsoft training courses.

Excel tip:

Selecting blank cells within a range of data

Select the range of data which includes the blank cells that you would like to select. Press the F5 key, this will take you to the GoTo dialogue box where you can click on Special and then select Blanks.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard