AVG Function not Updating Range

[tperk100]

Using AVG function across Row 62. If I insert new Row at 61, and then insert values in Row 61,
Row 63 functions update to include Row 61 range and values, EXCEPT G63 does not update.

Seems like a simple problem, but I am baffled. Help will be appreciated. Is this mini sheet uploaded correctly?

Heart Log.xls
	A	B	C	D	E	F	G
4	Date	Time	Sys	Dia	Pulse	Glucose	Weight
5
6
7	10/5/22	0900	110	83	60	86
8	10/6/22	0900	116	80	61	121
9	10/7/22	0900	131	79	72
10	10/8/22	1000	118	86	67
11	10/9/22	1100	136	97	66
12		1105	133	91	64
13	10/10/22	0830	140	78	70
14	10/11/22	0930	145	74	65
15	10/12/22	0900	130	86	74
16	10/13/22	1030	122	75	66
17	10/14/22	0900	125	75	59
18	10/15/22	0700	145	90	68
19		0730	111	70	74
20	10/16/22	1030	126	77	64	130
21	10/17/22	0930	120	86	64	118
22	10/18/22	0900	123	85	68	121
23	10/19/22	0930	137	86	59	118
24	10/20/22	1000	106	81	76	163
25		1005	123	90	61	171
26		1600	120	86	61	131
27	10/21/22	1200	117	91	69	120
28	10/22/22	0930	122	78	59	105
29	10/23/22	1300	130	76	71	120
30	10/24/22	0930	143	79	65
31		1435	122	84	63
32	10/25/22	1000	126	87	75	125
33	10/26/22	0700	123	77	61
34	10/27/22	0930	134	81	86	92
35	10/28/22	1130	151	86	54
36		1135	116	97	62	118
37	10/29/22	0800	115	88	72	115
38	10/30/22	1000	124	84	61	98
39	10/31/22	1000	124	86	69	134	229
40	11/1/22	0530	132	86	80	97
41	11/2/22	1130	128	85	76	105
42	11/4/22	0830	112	82	67	94	228
43	11/6/22	0800	118	81	64	87
44	11/8/22	0900	102	71	79	129
45	11/9/22	0800	117	72	40
46	11/10/22	0800	117	83	71	118
47		0805	134	67	75	119
48	11/11/22	0800	194	88	81
49		0810	130	90	69	100
50	11/12/22	0800	112	74	77	129
51	11/14/22	0830	116	71	68	111
52	11/16/22	0800	110	82	138	183
53		0810	128	81	84	186
54	11/17/22	1000	146	82	68	116	240
55		1005	132	72	88
56	11/18/22	1000	138	75	70	122
57	11/19/22	0900	134	83	64	120
58	11/21/22	0900	130	97	68
59	11/24/22	0900	141	86	56	88
60	11/27/22	1000	123	85	61	113
61
62	Average		127	82	69	120	232
Sheet1

Cell Formulas
Range	Formula
C62:F62	C62	=AVERAGE(C7:C60)
G62	G62	=AVERAGE(G7:G59)

 

[tperk100]

The table

Heart Log.xls
	A	B	C	D	E	F	G
3
4	Date	Time	Sys	Dia	Pulse	Glucose	Weight
5	DATE	Time	Systolic	Diastolic	Pulse	Glucose	Weight
6
7	10/5/22	0900	110	83	60	86
8	10/6/22	0900	116	80	61	121
9	10/7/22	0900	131	79	72
10	10/8/22	1000	118	86	67
11	10/9/22	1100	136	97	66
12		1105	133	91	64
13	10/10/22	0830	140	78	70
14	10/11/22	0930	145	74	65
15	10/12/22	0900	130	86	74
16	10/13/22	1030	122	75	66
17	10/14/22	0900	125	75	59
18	10/15/22	0700	145	90	68
19		0730	111	70	74
20	10/16/22	1030	126	77	64	130
21	10/17/22	0930	120	86	64	118
22	10/18/22	0900	123	85	68	121
23	10/19/22	0930	137	86	59	118
24	10/20/22	1000	106	81	76	163
25		1005	123	90	61	171
26		1600	120	86	61	131
27	10/21/22	1200	117	91	69	120
28	10/22/22	0930	122	78	59	105
29	10/23/22	1300	130	76	71	120
30	10/24/22	0930	143	79	65
31		1435	122	84	63
32	10/25/22	1000	126	87	75	125
33	10/26/22	0700	123	77	61
34	10/27/22	0930	134	81	86	92
35	10/28/22	1130	151	86	54
36		1135	116	97	62	118
37	10/29/22	0800	115	88	72	115
38	10/30/22	1000	124	84	61	98
39	10/31/22	1000	124	86	69	134	229
40	11/1/22	0530	132	86	80	97
41	11/2/22	1130	128	85	76	105
42	11/4/22	0830	112	82	67	94	228
43	11/6/22	0800	118	81	64	87
44	11/8/22	0900	102	71	79	129
45	11/9/22	0800	117	72	40
46	11/10/22	0800	117	83	71	118
47		0805	134	67	75	119
48	11/11/22	0800	194	88	81
49		0810	130	90	69	100
50	11/12/22	0800	112	74	77	129
51	11/14/22	0830	116	71	68	111
52	11/16/22	0800	110	82	138	183
53		0810	128	81	84	186
54	11/17/22	1000	146	82	68	116	240
55		1005	132	72	88
56	11/18/22	1000	138	75	70	122
57	11/19/22	0900	134	83	64	120
58	11/21/22	0900	130	97	68
59	11/24/22	0900	141	86	56	88
60	11/27/22	1000	123	85	61	113
61	12/2/22	1000	112	78	67
Sheet1

 

[Automatrix]

It still looks like a range of cells rather than a table. Does a Table Design section show up in the ribbon when you select a cell in the table?