Forum Discussion

henk_buurman's avatar
henk_buurman
Copper Contributor
Aug 12, 2020

Cannot insert or delete rows in a table

Greetings everyone.

 

Essentially as stated in the header, with the following additional information:

 

* This only applies to the first 35 rows

* No problem to insert or delete rows starting row 36

* There are no protections on the sheet or the workbook

* There are no defined edit ranges

 

Any ideas?

excel

10 Replies

Sort By
  • wumolad's avatar
    wumolad
    Iron Contributor
    Aug 13, 2020

    Hi henk_buurman 

     

    It might be difficult to assess the situation without the snapshot of the screen.

     

    If there is no confidential data in the file, you can share, so we can take a look together.

     

    Cheers

    • henk_buurman's avatar
      henk_buurman
      Copper Contributor
      Aug 13, 2020

      wumolad 

       

      thanks for replying. I have added to snapshots. As you can see, it is a sheet with ~70 columns and currently 200 rows that is used to plan IT colleagues on various projects. First column are names and fifth column are projects, blanked for obvious reasons. First pic shows right click on row <36 and second pic right click on row >35.

      Thanks

Resources