If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sharing workbook
I want share my workbook but to some user only, than others for read only.
How to setting that selected user for sharing. |
#2
|
|||
|
|||
sharing workbook
EXCEL 2007
Review tab / Changes group / Share Workbook / place a tick in the box called:- Allow changes by more than one user at the same time. This allows allows workbook merging. Hit OK. If my comments have helped please hit Yes. Thanks. "nordiyu" wrote: I want share my workbook but to some user only, than others for read only. How to setting that selected user for sharing. |
#3
|
|||
|
|||
sharing workbook
Excel has a Sharing feature that allows multiple users to update the file at the
same time. (In xl2003 menus, it's under tools|share workbook.) But most people would not suggest using this. Lots of people have had trouble with this -- and there are lots of features that are disabled when you share a workbook. If this is what you mean, you may want to consider using a real database application -- maybe Access???? These programs are made for this simultaneous updates. ====== If you meant that you wanted to just provide a workbook that others could update (not at the same time), you could save the file with a password. Show the SaveAs dialog. Tools|General Options|Give the file a password to modify. (make it memorable!) Then you can share that password with your updaters and not with the readonly crowd. (Ask that the password not be shared with others!!!) Like any other password, there are sites that help(?) crack passwords. Another option would be to put the file on a common network share that only some people have read/write/create/delete access -- and others only have read ability. You may need your IT staff's help for this. nordiyu wrote: I want share my workbook but to some user only, than others for read only. How to setting that selected user for sharing. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|