View original (French)

Do not modify part of the matrix

CANDIC5640 Posted messages 36 Status Member -  
CANDIC5640 Posted messages 36 Status Member -

Hello,

I have a problem when I want to delete or add a row (rows) in the file = "you cannot modify part of an array"

Being clueless in Excel, I haven't created any array formulas (?)

https://www.cjoint.com/c/MCvoNyoa0R0

Is there a way to "work around" this issue please?

Thank you for your help

Excel version: Microsoft Excel for Microsoft 365 MSO (version 2203 Build 16.01.15028.20152) 64 bits

2 answers

  1.
    The_boss_68 Posted messages 959 Registration date   Status Member Last intervention   182
     

    Good evening,

    Being terrible at Excel, I didn't create array formulas (?)

    In your file, each sheet has array formulas in Column U, Column V, and Column AW, so it's normal that you can't delete rows.

    And for your information.........you can only delete an array by selecting the ENTIRE array.

    I hope I was able to help you.

    Best regards

    0
  2. CANDIC5640 Posted messages 36 Status Member
     

    Hello,

    Thank you,

    indeed, when I delete the 2 columns (U and AW) I can add and delete rows

    if I re-enter the formulas it works (so a matrix formula is between { } )... I hadn't put those symbols in at the beginning???

    Best regards

    0