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

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!

Link to comment
Share on other sites

  • 1 year later...
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!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

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

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