Can't unshare workbook

M

Mr. m0le

I have a workbook with two marcos in it. I set it to share as it was going
to be passed around untill i realized that you can't import txt files into
the workbook while it's shared. I tried to go into tools, protection,
unshare and it changes the option in the menu to show share & protect but the
workbook itself is stuck on share in the title bar and i still can't import
txt files or anything. I've tried to save it this way and reload and other
such combinations without luck. Is there a way i can get this workbook
unshared completely so i can import txt files into it again?
 
M

Mr. m0le

Update: I came up with something that worked.... I copied each individual
sheet out of the workbook into a new workbook and the shareing and protection
was removed and i can import txt files and such again. Sry for any
inconvience i may have caused anyone if you where tryin to help me out with
this problem.
 
G

Gord Dibben

First remove protection by going to Tools>Protection>UnProtect.

Now go to Tools>Share Workbook and unshare it there.


Gord Dibben MS Excel MVP
 
M

Mr. m0le

Gord,
thx for the reply but if you read the original post I stated i tried that
without luck. I did get something to work though. I copied each sheet into
a new workbook and that fixed it.
 
G

Gord Dibben

You did not state that in your original post.

You stated only that you went into Tools>Protection and tried to unshare the
workbook.

There is no "unshare workbook" in Tools>Protection.


Gord
 
M

Mr. m0le

"I tried to go into tools, protection,
unshare and it changes the option in the menu to show share & protect but the
workbook itself is stuck on share" my wording may be a little off but here
it is.....
 
G

Gord Dibben

But have you tried Tools>Share Workbook and unchecking "Allow changes etc"

The workbook must be unprotected first.


Gord
 
M

Mr. m0le

This is where i ran into the problem... i couldn't unprotect it. It would
allow me to unshare and share it again but all the rest of the protection
options stayed grayed out no matter what i did....
 

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