kx3

The Command is not available in a shared workbook excel 2010

Recommended Posts

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!

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites
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!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Who's Online   0 Members, 0 Anonymous, 66 Guests (See full list)

    There are no registered users currently online