View original (French)

Do not modify part of the matrix

CANDIC5640 Posted messages 36 Status Membre -  
CANDIC5640 Posted messages 36 Status Membre -

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 réponses

Réponse 1 / 2
The_boss_68 Posted messages 959 Registration date   Status Membre 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
Réponse 2 / 2
CANDIC5640 Posted messages 36 Status Membre
 

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