Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL 2002
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: How is the Excel 2007 file format open in Excel 2002 ? | Excel Discussion (Misc queries) | |||
Excel 2002 : Unable to open files in MS Outlook 2002 | Excel Discussion (Misc queries) | |||
Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl | Excel Worksheet Functions | |||
Atomatic file name in excell 2002 from cel A1 (like in word 2002) | New Users to Excel | |||
Can you print labels using Excel 2002 in a Word 2002 mail merge? | Excel Discussion (Misc queries) |