Share via

Excel 2013: this command is not available in a shared workbook (workbook not shared)

  • Article

Question

Friday, January 29, 2016 7:02 AM

Hi Folks,

A staff member is using Excel 2013, and receives the error: "this command is not available in a shared workbook" when trying to copy an existing sheet as a new sheet.

The Workbook is not shared.

I don't receive the same error if I open the Workbook, and copy and paste the same sheet.

Help appreciated.

Regards,

Steve.

All replies (4)

Monday, February 1, 2016 6:52 AM âś…Answered | 2 votes

In   Review   >   Track   Changes   >   Highlight   Changes   >   un-ticked   "Track   changes   while   editing.   This   also   shares   your   workbook."

Monday, February 1, 2016 6:48 AM

Hi Steve,

Where did you use this file in local computer or network?

Based on your error message, it seems that turn on the Share option in Excel.

I suggest you try this method:

  1. Please go to Review then click Share Workbook option in Excel.
  2. Make sure uncheck the box "Allow changes by more than one user at the same time. This also allows workbook merging".

Now please check if it works fine now, if your issue still exists please provide more information about your issue.

I'm glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Support

Please mark the reply as an answer if you find it is helpful.

If you have feedback for TechNet Support, contact [email protected].

Monday, February 1, 2016 6:57 AM

Thanks for your help Emi.

Found the problem - see below.

Monday, February 1, 2016 7:01 AM

Hi Steve,

It's nice to hear you resolve your problem.

If you need more help when using Office product, please post your issue here.

We are glad to help and follow up your reply.

:D

PS: Don't forget mark your solution as answer.

Regards,

Emi Zhang
TechNet Community Support

Please mark the reply as an answer if you find it is helpful.

If you have feedback for TechNet Support, contact [email protected].