Usually you create a connection to a file system folder and add it to your library and your file exists in that folder:
(ooxml, embedded labels, table is Personnel);
Check that your created a connection in your library first. Simply typing lib://something doesn't create a connection in your library.
Alternatively use the Data Manager to load the data from the excel file. You'll be walked through a few screens and the connection will be made for you and the data loaded. You should see the tables, including the named tables, in excel on the third screen:
Thank you. It seems I wasn't clear. My issue is not how to load a table but how to load a named table.
In Excel, you can create an object Table and give it a name. From the name manager, you can reuse the object and its column. I wan wondering whether Qlikview can 'read' the named objects of a workbook, like a table or a named range.