Hi all,

I have just started using Excel 2003 sp1. I'm not having too hard of a time
except for this one issue....

-Is it possible to get into an excel sheet to just look at it and not have
the ability to do anything. Like, we have been using lotus and it has an
option to "release reservation". Does Excel have this option?


--
B Craig

Under "Format" menu, "Protection" tab - HIghlight the cells, or whole sheet
that you want to "protect", set your options, then come out of "Format" and
into "Tools" menu, then you have option to protect either worksheet or
workbook. When "Protected" anyone can open the file, but wont be able to
alter any of the protected cells.

"B Craig" wrote:

Hi all,

I have just started using Excel 2003 sp1. I'm not having too hard of a time
except for this one issue....

-Is it possible to get into an excel sheet to just look at it and not have
the ability to do anything. Like, we have been using lotus and it has an
option to "release reservation". Does Excel have this option?


--
B Craig

Hi

You can protect the sheet (from Tools menu: Protection/Protect Sheet). You
can protect the sheet with password, or without it (leave the password
blank).
Before protecting the sheet, you can set, which cells in which extent on
sheet are protected. For this, activate Protection tab of Format.Cells menu
item, with range you want settings to set selected (to set settings for
entire sheet, select it clicking on left upper corner of worksheet - into
intersection of row and column labels). On this tab you can selcted range to
be protected (user can't change any entries in range) or unprotected and to
be hidden (user don't see formulas, and can't activate cell edit mode, i.e.
when F2 is pressed, user has new, blank entry in cell) or unhidden. All
those settings will be activated only when the sheet is protected.


Arvi Laanemets



"B Craig" wrote in message
...
Hi all,

I have just started using Excel 2003 sp1. I'm not having too hard of a
time
except for this one issue....

-Is it possible to get into an excel sheet to just look at it and not have
the ability to do anything. Like, we have been using lotus and it has an
option to "release reservation". Does Excel have this option?


--
B Craig

Thank you to all who responded so quickly. But, I think I stated my question
wrong. What I want to be able to do is be in the file but leave it open so
someone else can get in it an modify it as they need to and yet let me be in
it as "read only".

Once again, thanks to Graham and Arvi for the response!

"B Craig" wrote:

Hi all,

I have just started using Excel 2003 sp1. I'm not having too hard of a time
except for this one issue....

-Is it possible to get into an excel sheet to just look at it and not have
the ability to do anything. Like, we have been using lotus and it has an
option to "release reservation". Does Excel have this option?


--
B Craig

Hi B Craig-

I don't thik Excel has the Lotus "feature" you seek, but it really doesn't
need it . If one user has the file open, another can open the same file for
read only access. Nothing special necessary except that the first user into
the file is the only one who can edit it. However, any changes made by the
first user will NOT be seen by the others who have the file open.

What you may want to look into is ToolsShare Workbook. This not only allows
multiuser access, but also simultaneous editing of the file as well as
control over which changes are accepted & resolving conflicts. Each user has
the benefit of seeing the saved changes made by others every time he saves
his work.

Hope this is useful |:)
"B Craig" wrote:

Thank you to all who responded so quickly. But, I think I stated my question
wrong. What I want to be able to do is be in the file but leave it open so
someone else can get in it an modify it as they need to and yet let me be in
it as "read only".

Once again, thanks to Graham and Arvi for the response!

"B Craig" wrote:

Hi all,

I have just started using Excel 2003 sp1. I'm not having too hard of a time
except for this one issue....

-Is it possible to get into an excel sheet to just look at it and not have
the ability to do anything. Like, we have been using lotus and it has an
option to "release reservation". Does Excel have this option?


--
B Craig

CyberTaz,

I'll check it out. This issue came up today when I was in a list just
looking around for info and one of the other guys wanted in the list to add
an entry. So, I had to get out, let him in and then get back in. Not a big
deal, but extra steps. I am definetly going to check out. Thanks for the
feedback.

"CyberTaz" wrote:

Hi B Craig-

I don't thik Excel has the Lotus "feature" you seek, but it really doesn't
need it . If one user has the file open, another can open the same file for
read only access. Nothing special necessary except that the first user into
the file is the only one who can edit it. However, any changes made by the
first user will NOT be seen by the others who have the file open.

What you may want to look into is ToolsShare Workbook. This not only allows
multiuser access, but also simultaneous editing of the file as well as
control over which changes are accepted & resolving conflicts. Each user has
the benefit of seeing the saved changes made by others every time he saves
his work.

Hope this is useful |:)
"B Craig" wrote:

Thank you to all who responded so quickly. But, I think I stated my question
wrong. What I want to be able to do is be in the file but leave it open so
someone else can get in it an modify it as they need to and yet let me be in
it as "read only".

Once again, thanks to Graham and Arvi for the response!

"B Craig" wrote:

Hi all,

I have just started using Excel 2003 sp1. I'm not having too hard of a time
except for this one issue....

-Is it possible to get into an excel sheet to just look at it and not have
the ability to do anything. Like, we have been using lotus and it has an
option to "release reservation". Does Excel have this option?


--
B Craig

CyberTaz,

Welp, I shared the workbook and it did exactly as we need, in fact, we can
now all enter info without kicking someone out. Man, we are steps ahead now!

Thanks again.

"CyberTaz" wrote:

Hi B Craig-

I don't thik Excel has the Lotus "feature" you seek, but it really doesn't
need it . If one user has the file open, another can open the same file for
read only access. Nothing special necessary except that the first user into
the file is the only one who can edit it. However, any changes made by the
first user will NOT be seen by the others who have the file open.

What you may want to look into is ToolsShare Workbook. This not only allows
multiuser access, but also simultaneous editing of the file as well as
control over which changes are accepted & resolving conflicts. Each user has
the benefit of seeing the saved changes made by others every time he saves
his work.

Hope this is useful |:)
"B Craig" wrote:

Thank you to all who responded so quickly. But, I think I stated my question
wrong. What I want to be able to do is be in the file but leave it open so
someone else can get in it an modify it as they need to and yet let me be in
it as "read only".

Once again, thanks to Graham and Arvi for the response!

"B Craig" wrote:

Hi all,

I have just started using Excel 2003 sp1. I'm not having too hard of a time
except for this one issue....

-Is it possible to get into an excel sheet to just look at it and not have
the ability to do anything. Like, we have been using lotus and it has an
option to "release reservation". Does Excel have this option?


--
B Craig