>> Stop sharing a workbook

[Jonathan Parminter]

Hi, I have a shared workbook. I now want to stop sharing
this workbook so that I can make some alterations to its
design.

I have tried to use the method described in online help to
turn off the sharing. But when I clear the checkbox,
respond 'yes' to the warning, the workbook remains shared
and, when I re-open the share workbook dialog, the
checkbox to allow changes by others is still
ticked/checked.

Any ideas or suggestions appreciated

Thanks
Jonathan

 

[Myrna Larson]

I can't reproduce this in Excel 2002, and I can't find anything about it in
the MS Knowledge Base.

 

[Dave Peterson]

When you look at the title bar, do you see [Shared]?

If yes, you didn't unshare it.

 

[Jonathan Parminter]

-----Original Message-----
When you look at the title bar, do you see [Shared]?

If yes, you didn't unshare it.

Thanks Dave, Yes it still says [shared]. Even with someone
looking over my shoulder to confirm that I am following
online help instructions I don't seem to be able to
unshare a workbook.

Jonathan

 

[Jonathan Parminter]

-----Original Message-----
I can't reproduce this in Excel 2002, and I can't find anything about it in
the MS Knowledge Base.

Thanks Myrna, I'm also using excel 2002.

Jonathan

 

[Dave Peterson]

Are you sure you're unchecking that "allow changes..." checkbox?

(or did you mean you got it working??)

-----Original Message-----
When you look at the title bar, do you see [Shared]?

If yes, you didn't unshare it.

Thanks Dave, Yes it still says [shared]. Even with someone
looking over my shoulder to confirm that I am following
online help instructions I don't seem to be able to
unshare a workbook.

Jonathan

--

Dave Peterson
(e-mail address removed)
.

 

[Jonathan Parminter]

Hi Dave, Yes I'm sure that I unchecked the "allow
changes..." checkbox which is why I asked someone in the
office to watch me - in case I was going crazy and wasn't
doing what I thought I was doing...

Jonathan

-----Original Message-----
Are you sure you're unchecking that "allow changes..." checkbox?

(or did you mean you got it working??)

-----Original Message-----
When you look at the title bar, do you see [Shared]?

If yes, you didn't unshare it.

Thanks Dave, Yes it still says [shared]. Even with someone
looking over my shoulder to confirm that I am following
online help instructions I don't seem to be able to
unshare a workbook.

Jonathan

Jonathan Parminter wrote:

Hi, I have a shared workbook. I now want to stop sharing
this workbook so that I can make some alterations to its
design.

I have tried to use the method described in online

help
to

turn off the sharing. But when I clear the checkbox,
respond 'yes' to the warning, the workbook remains shared
and, when I re-open the share workbook dialog, the
checkbox to allow changes by others is still
ticked/checked.

Any ideas or suggestions appreciated

Thanks
Jonathan

--

Dave Peterson
(e-mail address removed)
.

--

Dave Peterson
(e-mail address removed)
.

 

[Dave Peterson]

I don't have another guess.

Can the person who was watching unshare the workbook on his/her pc?

Hi Dave, Yes I'm sure that I unchecked the "allow
changes..." checkbox which is why I asked someone in the
office to watch me - in case I was going crazy and wasn't
doing what I thought I was doing...

Jonathan

-----Original Message-----
Are you sure you're unchecking that "allow changes..." checkbox?

(or did you mean you got it working??)

-----Original Message-----
When you look at the title bar, do you see [Shared]?

If yes, you didn't unshare it.


Thanks Dave, Yes it still says [shared]. Even with someone
looking over my shoulder to confirm that I am following
online help instructions I don't seem to be able to
unshare a workbook.

Jonathan

Jonathan Parminter wrote:

Hi, I have a shared workbook. I now want to stop sharing
this workbook so that I can make some alterations to its
design.

I have tried to use the method described in online help
to
turn off the sharing. But when I clear the checkbox,
respond 'yes' to the warning, the workbook remains
shared
and, when I re-open the share workbook dialog, the
checkbox to allow changes by others is still
ticked/checked.

Any ideas or suggestions appreciated

Thanks
Jonathan

--

Dave Peterson
(e-mail address removed)
.

--

Dave Peterson
(e-mail address removed)
.

 

[Jonathan Parminter]

Hi Dave,

thanks for sticking with this one. I've decided instead to
have linked workbooks. that is, each contibutor has their
own workbook. They are all linked to a summary workbook.

Thanks again for your persistance
Jonathan

-----Original Message-----
I don't have another guess.

Can the person who was watching unshare the workbook on his/her pc?

Hi Dave, Yes I'm sure that I unchecked the "allow
changes..." checkbox which is why I asked someone in the
office to watch me - in case I was going crazy and wasn't
doing what I thought I was doing...

Jonathan

-----Original Message-----
Are you sure you're unchecking that "allow changes..." checkbox?

(or did you mean you got it working??)

Jonathan Parminter wrote:

-----Original Message-----
When you look at the title bar, do you see [Shared]?

If yes, you didn't unshare it.


Thanks Dave, Yes it still says [shared]. Even with someone
looking over my shoulder to confirm that I am following
online help instructions I don't seem to be able to
unshare a workbook.

Jonathan

Jonathan Parminter wrote:

Hi, I have a shared workbook. I now want to stop sharing
this workbook so that I can make some alterations

to
its

design.

I have tried to use the method described in online help
to
turn off the sharing. But when I clear the checkbox,
respond 'yes' to the warning, the workbook remains
shared
and, when I re-open the share workbook dialog, the
checkbox to allow changes by others is still
ticked/checked.

Any ideas or suggestions appreciated

Thanks
Jonathan

--

Dave Peterson
(e-mail address removed)
.


--

Dave Peterson
(e-mail address removed)
.

--

Dave Peterson
(e-mail address removed)
.