Loading data from sharepoint file through QMC, failed with error: Error: Cannot read BIFF file

[kaicpa2]

Hello all

I have an issue for which I hope you can give me direction:

I have an excel file (xls) on a sharepoit (version 10) and:

- when I run the reloald from the desktop, the updated goes fine

- when running the reload from the QMC it fails and reading the Log file, the error is "Error: Cannot read BIFF file"

Let me say:

- The User Qlikview  running the service has full access to the sharepoint

- when running the report from the Desktop with the same  user (the one that run the QMC service) it works like a charm

- with previous version of the Sharepoint there were no issue like this

Thanks for you help

Carlo

[whiteline]

Hi.

It seems that QlikView User needs to login to have the access.

[#3]

You have to conect directly to each excel file using driver.

I was getting the same issue and i solved with attachment file example.

I hope it help you.