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

Sharing workbooks

ResolvedVersion 2003

Wed 8 Oct 2008, 15:30 Delegate Jillian said...

Jillian has attended:
Excel Advanced course

Sharing workbooks

I want to share workbooks with others can you please explain how to do this

Fri 10 Oct 2008, 15:16 Trainer Simon said...

RE: sharing workbooks

Hi Jillian,

Thank you for your question.

You can share a workbook by using the menu command Tools and then selecting share workbook and then tick the checkbox that begins 'allow changes by more than one user...'

Then you can save the file to a shared network folder and everyone can then make changes to the file at the same time.

I hope this answers your question.

Regards

Simon

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

View all Excel hints and tips

Sharing workbooks

Sharing workbooks

RE: sharing workbooks

Excel articles

Excel tip:

New Normal Worksheet