You have to create those sheet as 1,2,3..... . Please follow these step below:
Step 1. press Alt F11, double click on any sheets in the left of the opened window and copy the below code as shown in the below picture.
Sub renameSheets() Dim iSheetCount For iSheetCount = 1 To Sheets.Count Sheets(iSheetCount).Name = iSheetCount Next iSheetCount End Sub
Then run by clicking the run button like below
Save as the file in xlsx fomat.
Then Open the Qlikview file, Press Cntrl E, go to the code marked in red as shown in the below picture and change the number as equal to the sheets available in the file “Name of your Excel sheet” after running the macro. Assuming the file contain 290 sheets. Eg. for loop=1 to 290