Jump to content
groovyPost Forums

The Command is not available in a shared workbook excel 2010


Guest kx3

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!

Link to comment
Share on other sites

  • 2 weeks later...
  • 1 year later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

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

    • There are no registered users currently online
×
×
  • Create New...