Thread: EXCEL 2002
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default EXCEL 2002

Click TOOLs on the menu and click SHARE WORKBOOK. On the EDITING tab click
to check box ALLOW CHANGES BY MORE THAN ONE... to turn it on.

The ADVANCED tab lets you set track changes options, auto updates and
conflict resolution settings.
--
Kevin Backmann


"COMPLETE NOVICE" wrote:

I NEED TO CREATE A SPREAD SHEET WHICH CAN BE WORKED ON BY SEVERAL PEOPLE BUT
ONCE OPENED BY ONE PERSON CAN ONLY BE VIEWED BY THE OTHERS UNTIL THE PERSON
USING IT HAS SAVED THE INFO AND CLOSED THE FILE.

I have created one which presents others with "Read Only" copies BUT these
still permit them to make entries - which are then lost unless saved to a new
file.
Suggestions please
--
SN