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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
sharing workbooks

ResolvedVersion 2007

Adam has attended:
Excel Intermediate course

Sharing workbooks

Sharing workbooks,

Is there any way of sharing workbooks so that all work done on all versions is layed out together rather than over writing it?

RE: sharing workbooks

Hi Adam

Thank you for your question. In Excel 2007 Workbooks can be shared. They don't show multiple versions of a sheet but will show edits. Try this: from the Review tab, in the Changes group click Share Workbook On the Edit tab select Allow changes by more than one user at the same time (you will need to save the document).

Now when anyone edits the file a review comment is added to each edited cell noting the change and who made it.

The Review tab also allows you to accept or reject such edits. It won't unfortunately show all edits side by side.

I hope this goes some way to helping - do let us know if you have any further questions.

Kind regards,
Andrew

Tue 29 Dec 2009: Automatically marked as resolved.

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.