Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Can't unshare workbook

59 views
Skip to first unread message

Mr. m0le

unread,
Jul 8, 2009, 4:17:02 PM7/8/09
to

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?

Mr. m0le

unread,
Jul 8, 2009, 4:51:02 PM7/8/09
to

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.

Gord Dibben

unread,
Jul 8, 2009, 5:03:44 PM7/8/09
to

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

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


Gord Dibben MS Excel MVP

Mr. m0le

unread,
Jul 8, 2009, 5:15:01 PM7/8/09
to

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.

Gord Dibben

unread,
Jul 8, 2009, 6:23:53 PM7/8/09
to

You did not state that in your original post.

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

>>I tried to go into tools, protection, unshare

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


Gord

On Wed, 8 Jul 2009 14:15:01 -0700, Mr. m0le

Mr. m0le

unread,
Jul 8, 2009, 7:24:01 PM7/8/09
to

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

Gord Dibben

unread,
Jul 8, 2009, 8:44:19 PM7/8/09
to
But have you tried Tools>Share Workbook and unchecking "Allow changes etc"

The workbook must be unprotected first.


Gord

On Wed, 8 Jul 2009 16:24:01 -0700, Mr. m0le

Mr. m0le

unread,
Jul 8, 2009, 8:56:01 PM7/8/09
to
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....
0 new messages