sharing workbooks

[peyman]

Hi,
I just wanna know if it's possible to share a workbook for one user and at
the same time making it read-only for other user(s).

Thanx

 

[Gord Dibben]

What would be the purpose of sharing if only one user can write to the
workbook?

The purpose of shared workbooks is to allow multiple users to open and edit
simultaneously.


Gord Dibben MS Excel MVP

 

[MFS]

Hi peyman,

Check this page - Part 4 (Share data with other people):
http://office.microsoft.com/en-us/training/HA102189871033.aspx

It is A roadmap to Excel 2007 training provided by Microsoft Office, but it
might help you.
If you still do not have Office 2007, I recommend that you try it, because
there are many things Microsoft Office has improved, you may refer to this
page to understand what has been changed and how to use it.

 

[peyman]

Thanx, I'm using Office 2007.

Hi peyman,

Check this page - Part 4 (Share data with other people):
http://office.microsoft.com/en-us/training/HA102189871033.aspx

It is A roadmap to Excel 2007 training provided by Microsoft Office, but it
might help you.
If you still do not have Office 2007, I recommend that you try it, because
there are many things Microsoft Office has improved, you may refer to this
page to understand what has been changed and how to use it.

 

[peyman]

Hi Gord,
It doesn't seem to be weird if you make a file shared to some users and at
the same time Read-only for other users. For example , for a shipping plan
excel file, I need it shared for Plannig Manager and Production Manager so
that they can update it but at the same time I need my Shipping department
only see the shipping plan with no access to change any data on the file.
I hope it's clear for you.
Peyman