Forum Discussion

Val_L's avatar
Val_L
Copper Contributor
Nov 06, 2019

Can't Add Worksheet and/or Move/Copy Worksheet in Excel File

All of a sudden, I cannot add a worksheet or move/copy a worksheet within an excel file I have been working with.  The file is shared with other co-workers.  I can complete this function in other files.  Looking for help to solve this problem.

excel

7 Replies

Sort By
  • JingLiu001's avatar
    JingLiu001
    Former Employee
    May 12, 2022
    Open the excel in Desktop, you can not Move or Copy when it is opened in Web.
  • Nik_B4000's avatar
    Nik_B4000
    Copper Contributor
    Aug 13, 2021

    Val_L 

    I had the same issue now (August 2021) but could solve it.

    It turned out that it was a format issue of the Excel sheet.

    ".xlsx" vs. ".xls" ("Excel Worksheet" against "Excel 97-2003 Worksheet").

    Both worksheets need to have the same format in order to copy or move sheets properly.

  • PReagan's avatar
    PReagan
    Bronze Contributor
    Nov 06, 2019

    Hello Val_L,

     

    Make sure the workbook is not protected. In the Review Tab, go to Protect Workbook. If you are prompted to unprotect the workbook, then a password is set to protect the workbook already.

    • Val_L's avatar
      Val_L
      Copper Contributor
      Nov 06, 2019

      PReagan  the workbook is protected and I have already unprotected it.  I am able to modify existing worksheets.

       

      • mmikes1031's avatar
        mmikes1031
        Copper Contributor
        Jun 24, 2021

        I have always been able to copy a worksheet from one file and paste it into a second file.  both worksheets are unprotected but i still cannot copy.  HELP I have a paystub to get out.  I would have a calculations tab and then bring the final numbers into a stub then copy the pay stub into a new file to be sent out.  I cannot do any of the copying and I can't  add a new worksheet or tab to the current pay stub tab that id dent out. 

         

        Peggy

Resources