unable to read .xlsx file

[Anonymous]

Hi All,

I am having some .xlsx files feeding into qlikview.

When I reload my dashboard it is unable to read the excel file.

I need to open & save the excel file & then qlikview is able to read it.

I have around 25 excels feeding into qlikview and need to manually open & save everytime before refreshing my dashboard.

please help ...

[jonathandienst]

SAS is probably not structuring the file correctly. I have seen that of other Enterprise software as well.

Excel is very tolerant of problems with the internal structure, but the Qlikview loader is not. Loading and saving the file fixes the internal structure. Consider exporting a CSV from SAS as an alternative.

[jonathandienst]

Go to the advanced editor. You can upload files from there:

[andrei_delta]

Hi!

Have you checked the security rights on those xlsx's for permissions?

Hope it helps,

Andrew