Filtered Rows prints 7 pages when print area is set to 2

[angusn]

Hello Everyone. I was looking for a bit of help since I didn't find the exact problem here and Google was just an avalanche of ideas that haven't worked.

What's going on is that I have a time tracker of sorts made up and the issue is when I sort it by the week of the year, there tends to be 7 blank pages before, after or both when the print area is set to 2 pages depending on the week I choose and I have no idea what it triggering it. I went so far as deleting all cells that have no data, removed formatting from absolutely everything on the sheet and probably reapplied the print area two dozen times. I'm hoping this is a really simple fix for which I'm blind for looking because I'm just stumped.

I tired making a GIF but the size was too big so I made a little YouTube video to show it better.

Google Drive Folder to File - MrExcel - Google Drive

I also tried doing the Mini-Sheet add-on but it would only take the first week of cells.

Thanks in advance.

Help Labour Tracker - Sample v6.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M
2	Sun May 28 - Sat Jun 03		Subtotal:	5.00		Subtotal:	96.75		Subtotal:	66.50
3	Week	Employee	PM Job #	PM	Column1	Model Job #	Model / Detail	Column2	Eng. Job #	Engineering	Column3	Total Hours per Employee
4	1	User 1	Holder	5.00					Holder	20.00
5	1	User 1
6	1	User 1
7	1	User 1
8	1	User 1
9	1	User 1
10	1	User 1
11	1	User 1
12	1	User 1
13	1	User 1										25.00
14	1	User 3
15	1	User 3
16	1	User 3
17	1	User 3
18	1	User 3
19	1	User 3
20	1	User 3
21	1	User 3
22	1	User 3
23	1	User 3										0.00
24	1	User 7
25	1	User 7
26	1	User 7
27	1	User 7
28	1	User 7
29	1	User 7
30	1	User 7
31	1	User 7
32	1	User 7
33	1	User 7										0.00
34	1	User 2
35	1	User 2
36	1	User 2
37	1	User 2
38	1	User 2
39	1	User 2
40	1	User 2
41	1	User 2
42	1	User 2
43	1	User 2										0.00
44	1	User 4
45	1	User 4
46	1	User 4
47	1	User 4
48	1	User 4
49	1	User 4
50	1	User 4
51	1	User 4
52	1	User 4
53	1	User 4										0.00
54	1	User 5
55	1	User 5
56	1	User 5
57	1	User 5
58	1	User 5
59	1	User 5
60	1	User 5
61	1	User 5
62	1	User 5
63	1	User 5										0.00
64	1	User 8
65	1	User 8
66	1	User 8
67	1	User 8
68	1	User 8
69	1	User 8
70	1	User 8
71	1	User 8
72	1	User 8
73	1	User 8										0.00
74	1	User 6
75	1	User 6
76	1	User 6
77	1	User 6
78	1	User 6
79	1	User 6
80	1	User 6
81	1	User 6
82	1	User 6
83	1	User 6										0.00
2024

Cell Formulas
Range	Formula
B2	B2	=INDEX(A:A,MIN(IF(SUBTOTAL(3,OFFSET(A4,ROW(A4:A4243)-ROW(A4),0)),ROW(A4:A4243))))
E2,K2,H2	E2	=SUBTOTAL(9,E4:E4243)
M13,M83,M73,M63,M53,M43,M33,M23	M13	=SUM(D4:K13)

Named Ranges
Name	Refers To	Cells
'2024'!Print_Titles	='2024'!$2:$3	B2