Unable to add/delete rows due to arrays

[irontis]

Hi guys,

I have been trying for a while to fix this issue with the arrays in this file. I have quite basic knowledge, and I was trying to get help through tutorial. However, everything seems to be related to arrays, but not to my specific case. I am always in need to add/delete rows because of the addition of names. However, it doesn't let me as "You can't change part of an array".

Now I once got so mad that instead to try and find a solution, I have created the file from 0 again. That obviously didn't change much as next time I opened the file, I was back at it.

This is the data I am working with:

10. October.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP
4		ENROLMENTS																																		ATTACHMENTS
5
6		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	Total			1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	Total
7	WOM																																		WOM
8	Michal																																0		Michal																																0
9	WDM																																		WDM
13	Manuel																																0		Manuel																																0
14	Andrea																																0		Andrea																																0
15	Andrea																																0		Andrea																																0
16	Alfonso																																0		Alfonso																																0
17	Matthew																																0		Matthew																																0
18	LWA																																		LWA
19	Katelyn																																0		Katelyn																																0
20	Theresa																																0		Theresa																																0
21	RC																																		RC
22	Daniele																																0		Daniele																																0
23	INSIDER																																		INSIDER
24	David																																0		David																																0
25	WDA																																		WDA
26	Charles																																0		Charles																																0
27	Paula																																0		Paula																																0
28	Sonia																																0		Sonia																																0
29	Anna																																0		Anna																																0
30	Olha																																0		Olha																																0
31	Puneet																																0		Puneet																																0
32	Stephanie																																0		Stephanie																																0
33	Sebastian																																0		Sebastian																																0
34	Fatima																																0		Fatima																																0
35	Elizabeth																																0		Elizabeth																																0
36	Total Per Day	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		Total Per Day	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Daily Enrolments

Cell Formulas
Range	Formula
AH8,BP26:BP36,AH26:AH36,BP24,AH24,BP22,AH22,BP19:BP20,AH19:AH20,BP13:BP17,AH13:AH17,BP8	AH8	=SUM(C8:AG8)
AK36:BO36,C36:AG36	C36	=SUM(C8:C35)

Can someone help me to undestand what's the issue or what I am doing wrong in this case?

Thanks in advance

 

[bebo021999]

I tried with the mini sheet sample and it seems OK for me.
"You can't change part of an array" notice usually happens with merge cells copy/paste, but i am not sure its your case.
May be try to un-merge cells before insert/remove rows?

 

[Fluff]

Do you have any other formulae on that sheet outside of the range you posted?

 

[irontis]

Do you have any other formulae on that sheet outside of the range you posted?

On that actual sheet, not at all. I selected the range of cells where all the formulas are. I have a second sheet in the workbook with many formulas connected to the main sheet you already saw. Do you think it could be related?

 

[Fluff]

No, the only time I have had the "You can't change part of an array" error is when you have a formula in multiple cells & you have selected the range & then confirmed the formula with Ctrl Shift Enter

 

[Peter_SSs]

the only time I have had the "You can't change part of an array" error is when you have a formula in multiple cells & you have selected the range & then confirmed the formula with Ctrl Shift Enter

It doesn't appear related to this thread but the other place I have seen it is sometimes arrays emanating from spill range arrays rather that Ctrl+Shift+Enter specifically. For example if you try to sort column C below

22 09 23.xlsm
	C
1	1
2	2
3	3
4	4
5	1
6	2
7	3
8	4
Sample

Cell Formulas
Range	Formula
C5:C8	C5	=SEQUENCE(4)
Dynamic array formulas.

@irontis
If you would like further investigation and you can remove or disguise any sensitive data, could you upload a sample file to DropBox or OneDrive or Google Drive etc and provide a shared link here in your thread?