The Command is not available in a shared workbook excel 2010

Microsoft Office Questions, Tips, etc... || Outlook, Word, Excel, Powerpoint, Access

The Command is not available in a shared workbook excel 2010

Postby kx3 » Wed Apr 28, 2010 1:28 pm

Hey there,

I'm working in Excel 2010 and I'm trying to copy a tab on my excel workbook but I keep getting this error message:

The Command is not available in a shared workbook

It was a bit of a pain but I figured out how to fix it.

1 - I click the REVIEW tab then Click Share Wordbook Icon in Excel 2010
2 - Unchecked the box "Allow changes by more than one user at the same time. This also allows workbook merging".

After that things worked just fine. I was able to copy the tab then rename it. Then I re-enabled sharing and was back in business.

I hope this helps someone else out there!
kx3
Hint of Groove
Hint of Groove
 
Posts: 27
Joined: Thu Mar 04, 2010 3:32 pm

Re: The Command is not available in a shared workbook excel 2010

Postby Austin » Wed Apr 28, 2010 9:58 pm

Thanks for the heads up on that, I haven't worked too much in Excel 2010 yet so I'll lookout for this one.
Got a simple question? Ask away on our new answers site.

Have a more difficult computer question or problem? Register a free account on the groovyPost Community Forum one of the talented members of the community will be here to help you out!
User avatar
Austin
Groovy Contributor
Groovy Contributor
 
Posts: 222
Joined: Sat Sep 29, 2007 5:10 pm
Location: groovyPost

Re: The Command is not available in a shared workbook excel 2010

Postby kx3 » Thu May 13, 2010 11:27 am

awesome find. thanks for this. I'm still playing with Office 2010 and there is so much new stuff I'm a bit lost. Having fun with it tho!
kx3
Hint of Groove
Hint of Groove
 
Posts: 27
Joined: Thu Mar 04, 2010 3:32 pm

Re: The Command is not available in a shared workbook excel 2010

Postby nirbhar » Wed May 18, 2011 10:55 am

Thanks.
This saved my precious time. I have been mangling my Office2010 for many days to correct this problem.
Nirmal
nirbhar
Newbie
Newbie
 
Posts: 1
Joined: Wed May 18, 2011 10:49 am

Re: The Command is not available in a shared workbook excel 2010

Postby Steve » Sun May 22, 2011 7:49 am

nirbhar wrote:Thanks.
This saved my precious time. I have been mangling my Office2010 for many days to correct this problem.
Nirmal


Yeah this is a good one especially if your new with Excel 2010 sharing. - BTW Welcome to the site! This looks like your first post!
- Steve Krause
groovyPost.com
User avatar
Steve
groovyPost Founder
groovyPost Founder
 
Posts: 906
Joined: Fri Sep 12, 2003 10:45 am


Return to Microsoft Office

 


  • Related topics
    Replies
    Views
    Last post

Who is online

Users browsing this forum: Bing [Bot], Google Adsense [Bot] and 32 guests