Bad Zip File - error when trying to access Excel file

[Anonymous]

Hi All,

I wonder if You guys can help with following situation:

I am trying to load data from Excel (xslx) file stored on Office 365 team site. I am using 'Web Files' button and I keep receiving Bad Zip File error.  I am sure that link that I have is correct - when I click on it - it's opening the file in Excel online application.

Before Team Site migration to Office 365, this way of loading data was working on my Desktop Qlikview(ver 11).

Now, after migration, I receive the same error for my desktop version (11) and also server version (12).

Thank You in advance.

Paulina

[balabhaskarqlik]

Try with these:

A solution that fixed this error from server.

Remotely Login to Qlik Server Service Account

Open IE and add the SharePoint sites to the

Sites       IE-->Tools-->Security-->Local Intranet-->Sites.

Another:

May be temporary files in folder,  those files were the problem.

Erase temporary files in folder. You can find them by selecting "show hidden files, folders, and drives" and not selecting "hide protected operating system files" in Tools/Folder Options, sheet View.

OR Load your tables like this:

LOAD *

FROM $(vFilepath)xyz.xls

(biff, embedded labels, table is [Report$]) ; (see for the value biff)

[balabhaskarqlik]

You may check this link:

Office 365 Excel file how to connect in Qlik View