Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Not applicable

Table Wizard shows deleted Excel worksheets

I'm a newbee in Qlikview and couldn't find any answer on excel support sites for my problem.

When I choose the table wizard in the script editor and I choose an excel file there is an option to change the table.

The names of the tables are the same as the name of the sheets in the excel workbook.

Only: it shows also the names of sheets that are deleted.

This specific file is used for certain editing on other data sources. But 'old' sheets in this file keep on showing up.

I've searched a lot for 'hidden' and 'very hidden' excel sheets. These old sheets can't be seen in excel.

Is there to 'clean' the list of tables to choose from in the table wizard?

Tags (3)