Qlikview Bad Zip File?

[#1]

This part of the code gives me the error which is baffling me, can anyone help me with this?:

LOAD Target,
Actual as CP_Actual,
Month as CP_Month
FROM [\\navy\data\QUALITY\CAR\LOG\2010 CAR log.xls]
(ooxml, embedded labels, table is [DWO Corrective Preventive Actio], filters(
Remove(Row, Pos(Top, 6)),
Remove(Row, Pos(Top, 2)),
Remove(Row, Pos(Top, 1)),
Remove(Col, Pos(Top, 14)),
Remove(Col, Pos(Top, 14)),
Rotate(right)
));

the error it gives me is-

Bad Zip File
LOAD Target,
Actual as CP_Actual,
Month as CP_Month
FROM [\\navy\data\QUALITY\CAR\LOG\2010 CAR log.xls]
(ooxml, embedded labels, table is [DWO Corrective Preventive Actio], filters(
Remove(Row, Pos(Top, 6)),
Remove(Row, Pos(Top, 2)),
Remove(Row, Pos(Top, 1)),
Remove(Col, Pos(Top, 14)),
Remove(Col, Pos(Top, 14)),
Rotate(right)
))

and then it shows 'Sheet properties' with available fields(which i think is normal) and then it also opens up the 'Edit Module' window.

I am very new to qlkview, so I am sorry if it sound like I dont know anything, because I kinda dont.

Also there is actually no zip file involved

Thanks,

Raj

[#2]

Hi - I've just had this too.

The spreadhseet that Qlikview was loading from crashed yesterday and although the user was able to recover the excel spreadsheet and excel seemed fine, Qlikview didn't seem to like it. I tried renaming the spreadhseet etc to no avail but I copied the worksheets one by one to a new spreadsheet and saved it under the same name as the old one and Qlikview seems happy.

Not a very neat solution but it works!

[dgy]

I had the same problem, it was caused by the spreadsheet being password-protected.