Sharing Workbooks

Resolved · Urgent Priority · Version 2003

Thu 3 Apr 2008, 16:23 Delegate Victoria said...

Victoria has attended:
Excel Intermediate course
Excel Advanced course

Sharing Workbooks

Dear Best Training,

Please could you tell me if it is possible to share a workbook and have two users using the same document at the same time?

I have two colleagues currently investigating the help options but they have not found the answer they are looking for.

Thank you very much!

Vicky

Thu 3 Apr 2008, 17:33 Trainer Amanda said...

RE: Sharing Workbooks

Hi Victoria

Thank you for your question.

There is a Share Workbook option in Excel which you can use so that more than one person can edit the same workbook at once.

In Excel 2003, go to Tools - Share Workbook.
On the Editing tab, tick the Allow changes by more than one user at the same time box.

On the Advanced tab, set up further options to control change tracking, history and conflicts.

Then click OK.

I hope this helps.
Amanda

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips

Sharing Workbooks

Sharing Workbooks

RE: Sharing Workbooks

Excel articles

Excel tip:

Hide data in Excel Worksheets