Hi @Tigerfox , as @Kazimierz indicated, it is easier to offer help with what is almost certainly a configuration option, if you can either upload the workflow, or show us your configuration. Otherwise there is a lot more guesswork involved.
I can say though, that a common mistake here is to not include all of the required configuration. Usually people forget/don’t realise that even though they have identified the use of “sheet” as the flow variable:
it is also necessary to configure the Excel Reader to ensure it is actually using the sheet name.
i.e. Select sheet “by name”. The default is “first sheet”, in which case sheet name flow variable will be ignored.
I would guess that one or other of the above steps have been missed.
In the past there have been some issues noted with setting sheet by flow variable. See
Although for me, sheet selection by name appears to work, AP-18133 does appear as a fix in the changelog for the upcoming KNIME 5.3 release, so if it’s still not working for you, the workaround mentioned by @mlauber71 in the above post, is probably the way to go.