Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sharing sheet
Hi, I have an excel form with 2 sheets. My excel form is sharable (for 30 users). My question is : How to share my sheets, like this way when the user 1 who's working on the sheet1 save the form, the user2 who's working on sheet 2 doesn't overwrite the changes of the user1. How to do that? Thanks for your help -- ecohen1 ------------------------------------------------------------------------ ecohen1's Profile: http://www.excelforum.com/member.php...o&userid=12988 View this thread: http://www.excelforum.com/showthread...hreadid=493510 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sharing sheet
any help??? -- ecohen1 ------------------------------------------------------------------------ ecohen1's Profile: http://www.excelforum.com/member.php...o&userid=12988 View this thread: http://www.excelforum.com/showthread...hreadid=493510 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sharing sheet
Tools Shareworkbook
(1) on the Editing tab check the box to allow the workbook to be used by more the one person at a time (2) on the Advanced tab, under Conflicting changes between users, choose the choice that you prefer. "ecohen1" wrote: Hi, I have an excel form with 2 sheets. My excel form is sharable (for 30 users). My question is : How to share my sheets, like this way when the user 1 who's working on the sheet1 save the form, the user2 who's working on sheet 2 doesn't overwrite the changes of the user1. How to do that? Thanks for your help -- ecohen1 ------------------------------------------------------------------------ ecohen1's Profile: http://www.excelforum.com/member.php...o&userid=12988 View this thread: http://www.excelforum.com/showthread...hreadid=493510 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
Index/Contents Sheet | Excel Discussion (Misc queries) | |||
In Excel, how do you make one whole sheet equal to another. | Excel Discussion (Misc queries) | |||
Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel |