Dependent/filtered data validation dropdown list not refreshing table filter to one record by slicer.

[LostInSwiss]

A real edge case this one.

Background
I am modifying an excel based survey workbook that is locked down, cannot contain VBA or ActiveX controls.

Setup

• I have a 2 tables Filter and Items. The Filter table has the headings ID, Item and Selection.
• The Items table contains the headings Item and Type.
• The selection column of the Filter table is populated by a data validation list (dropdown) based on the Type for the corresponding Item in the Items table using the formula

  =OFFSET(Items[@Item],MATCH(Filter[@Item],Items[Item],0)-1,1,3,1)

  This works as expected.
• Windows 11, Office 2016

Issue
When the Items table is filtered to a single record using a slicer while the selection validation works correctly at first, the validation dropdown arrow and its selection contets does not refresh/update when filtering with the slicer to another single record, unless any cell is selected first. The issue only occurs when filtering the Items table to a single record, if multiple records are shown in the Items table there is no issue.

slicerissue.xlsx
	A	B	C	D
1	ID	Item	Selection
2	1	Computer
3	3	Transport
4	5	Home
5
6
7
8
9
10
11
12
13
Filter

Cells with Data Validation
Cell	Allow	Criteria
C2:C4	List	=OFFSET(Items!$A$2,MATCH($B2,Items!$A$2:$A$10,0)-1,1,3,1)

slicerissue.xlsx
	A	B	C
1	Item	Type
2	Computer	High end
3	Computer	Mid range
4	Computer	Budget
5	Transport	SUV
6	Transport	Family
7	Transport	Hatchback
8	Home	Apartment
9	Home	Single family home
10	Home	Boat house
11
12
Items

EDIT: The minisheet does not add the slicer. Add a slicer to the filter table using the ID as the selection to replicate the issue.