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

  • Question

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

    Friday, January 29, 2016 7:02 AM

Answers

All replies

  • 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 tnmff@microsoft.com.
    Monday, February 1, 2016 6:48 AM
    Moderator
  • In   Review   >   Track   Changes   >   Highlight   Changes   >   un-ticked   "Track   changes   while   editing.   This   also   shares   your   workbook."
    Monday, February 1, 2016 6:52 AM
  • Thanks for your help Emi.

    Found the problem - see below.

    Monday, February 1, 2016 6:57 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 tnmff@microsoft.com.
    Monday, February 1, 2016 7:01 AM
    Moderator