sharing workbook

N

nordiyu

I want share my workbook but to some user only, than others for read only.
How to setting that selected user for sharing.
 
T

trip_to_tokyo

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.
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top