multi user

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Multi user

Multi user

resolvedResolved · Low Priority · Version 2003

David has attended:
Excel Intermediate course
Excel Advanced course

Multi user

Is it possible for more than 1 person to work on the same worksheet at the same time?

RE: multi user

Hi David,

Thank you for your question.

If you go to Tools and then Share Workbook. Click the checkbox that allows changes by more than one person. Then confirm the save dialogue box. The word Shared should appear in square brackets next to the filename.

Make sure the file is on a shared network that everyone has permissions to access.

Now more than one person can open it up at the same time.

I hope this answers your question.

Regards

Simon

Mon 7 Feb 2011: Automatically marked as resolved.


 

Excel tip:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips


Server loaded in 0.08 secs.