Cannot read BIFF file from Sharepoint

[Anonymous]

Hi,

I am trying to read xls file from Sharepoint via UNC path. When I load the data via QlikView I can load it without any issues.

But when it is reading via QlikView server, it fails.

Error : Cannot read BIFF file.

The UNC path example used to load data is,

FROM

[http://team.abc.com/Reports/HistoricalReports/Cost.xls]

(biff, embedded labels, header is 3 lines, table is [Funding$])

The Qlikview server group has READ access to this path.

Let me know if anyone could help to solve this issue.

Thanks.

[marcus_sommer]

Are you sure that the server-user had all neccessary access rights? Maybe there are further security restrictions with group policies, firewalls, port-blocking and similar.

- Marcus

[#3]

Here you are an example to solve this issue.

I hope it help you!