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

      • mmikes1031's avatar
        mmikes1031
        Copper Contributor
        Jun 24, 2021
        sorry to confuse folks - this is a new post not a reply. i have this problem right now, in June 2021!

Resources