Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
alexis
Partner - Specialist
Partner - Specialist

Invalid path error opening Excel - Workaround found, but why?

I have a very unusual problem with the Qlik Sense Desktop edition for which I found a solution but cannot explain it so I would welcome suggestions:


a) I create a Connection to the folder that stores my Excel files. The connection path is:


C:\Users\alexi\Documents\Qlik\Sense\DataSources\


When I select the Excel file using "Select Data" I get:

_delete1.jpg



b) When I create another connection but this time using the machine name instead of "C:"


\\LAPTOP-H0E3M650\Users\alexi\Documents\Qlik\Sense\DataSources\


and selected the same Excel file and all is fine. I can select the file, the script gets inserted and the data loaded fine when I load data.


LOAD

    ObjectType,

    ObjectDescription

FROM [lib://ExcelTest2/SAPObjectTypes.xlsx]

(ooxml, embedded labels, table is Sheet1);

Can someone PLEASE throw some light on this?

Regards

Alexis

0 Replies