Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Excel / November 2007



Tip: Looking for answers? Try searching our database.

shared workbook questions

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
designermonkey@hotmail.co.uk - 26 Nov 2007 14:56 GMT
I need to share a workbook between 8 people, I understand the process
of sharing the workbook, but what I need to know is:

If one user starts to insert information into one row (i.e. row 2) and
another user starts to do the same, how can I get the workbook to make
the information entered into two rows?

The worksheet is a list of all the ongoing work that our team does,
and because we are always receiving new work, the sheet will get
updated regularly which means that I need the above to be possible to
make sure that all new work is recorded in it's own row.

Is this possible at all?
Jim Gordon MVP - 27 Nov 2007 01:39 GMT
Hi,

Yes, this is already taken care of for you by Excel.

Use Tools > Share Workbook.  Click the Advanced tab for additional options.
You can decide which changes "win" when you turn sharing on.

As a bonus, the people sharing the workbook can be both PC and Mac users
simultaneously. Excel is the only product that I know of that supports this
kind of sharing.

-Jim

Quoting from "designermonkey@hotmail.co.uk" <designermonkey@hotmail.co.uk>,
in article
33248472-acea-4393-94f5-101e8727ec3a@e23g2000prf.googlegroups.com, on [DATE:

> I need to share a workbook between 8 people, I understand the process
> of sharing the workbook, but what I need to know is:
[quoted text clipped - 9 lines]
>
> Is this possible at all?

Signature

Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info http://mvp.support.microsoft.com/

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.