Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 17
Default Can't unshare workbook

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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 17
Default Can't unshare workbook

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.

"Mr. m0le" wrote:

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?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Can't unshare workbook

First remove protection by going to ToolsProtectionUnProtect.

Now go to ToolsShare Workbook and unshare it there.


Gord Dibben MS Excel MVP

On Wed, 8 Jul 2009 13:17:02 -0700, Mr. m0le
wrote:

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?


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 17
Default Can't unshare workbook

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" wrote:

First remove protection by going to ToolsProtectionUnProtect.

Now go to ToolsShare Workbook and unshare it there.


Gord Dibben MS Excel MVP

On Wed, 8 Jul 2009 13:17:02 -0700, Mr. m0le
wrote:

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?



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Can't unshare workbook

You did not state that in your original post.

You stated only that you went into ToolsProtection and tried to unshare the
workbook.

I tried to go into tools, protection, unshare


There is no "unshare workbook" in ToolsProtection.


Gord

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

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" wrote:

First remove protection by going to ToolsProtectionUnProtect.

Now go to ToolsShare Workbook and unshare it there.


Gord Dibben MS Excel MVP

On Wed, 8 Jul 2009 13:17:02 -0700, Mr. m0le
wrote:

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?






  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 17
Default Can't unshare workbook

"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" wrote:

You did not state that in your original post.

You stated only that you went into ToolsProtection and tried to unshare the
workbook.

I tried to go into tools, protection, unshare


There is no "unshare workbook" in ToolsProtection.


Gord

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

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" wrote:

First remove protection by going to ToolsProtectionUnProtect.

Now go to ToolsShare Workbook and unshare it there.


Gord Dibben MS Excel MVP

On Wed, 8 Jul 2009 13:17:02 -0700, Mr. m0le
wrote:

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?




  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Can't unshare workbook

But have you tried ToolsShare Workbook and unchecking "Allow changes etc"

The workbook must be unprotected first.


Gord

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

"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" wrote:

You did not state that in your original post.

You stated only that you went into ToolsProtection and tried to unshare the
workbook.

I tried to go into tools, protection, unshare


There is no "unshare workbook" in ToolsProtection.


Gord

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

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" wrote:

First remove protection by going to ToolsProtectionUnProtect.

Now go to ToolsShare Workbook and unshare it there.


Gord Dibben MS Excel MVP

On Wed, 8 Jul 2009 13:17:02 -0700, Mr. m0le
wrote:

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?





  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 17
Default Can't unshare workbook

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

"Gord Dibben" wrote:

But have you tried ToolsShare Workbook and unchecking "Allow changes etc"

The workbook must be unprotected first.


Gord

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

"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" wrote:

You did not state that in your original post.

You stated only that you went into ToolsProtection and tried to unshare the
workbook.

I tried to go into tools, protection, unshare

There is no "unshare workbook" in ToolsProtection.


Gord

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

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" wrote:

First remove protection by going to ToolsProtectionUnProtect.

Now go to ToolsShare Workbook and unshare it there.


Gord Dibben MS Excel MVP

On Wed, 8 Jul 2009 13:17:02 -0700, Mr. m0le
wrote:

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?






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I UNSHARE an Excel Workbook Barb Reinhardt Excel Discussion (Misc queries) 2 November 20th 08 03:14 PM
how to unshare a workbook? Todd Excel Worksheet Functions 3 April 9th 08 10:09 PM
Unshare a Shared Workbook Dave Excel Discussion (Misc queries) 1 February 1st 08 09:11 PM
Can't UNshare a shared workbook Phrank Excel Discussion (Misc queries) 1 January 27th 07 03:59 PM
unshare workbook mlh Setting up and Configuration of Excel 1 September 28th 06 02:29 PM


All times are GMT +1. The time now is 12:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"