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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can't open excel files withQlikView

Hi

I cant open excelfiles with qlikview even though they are not protected, can it be a user access issue?

13 Replies
yblake
Partner - Creator II
Partner - Creator II

using "\\host\path" syntax assumes that "path" is a network shared path.

Can you see "QlikView" shared folder when exploring \\192.168.101.130 host thru the network ? Can you open excel file remotly in exempel subfolder ?

Not applicable
Author

is there anyone that as an idea why i as a user can reach the files with local path like d:\QlikView\files, and not through a network path like \\someCompNameOrIP\QlikView\files?

Not applicable
Author

i found the error, i could see and get the files since i had permissions on them, but had forgotten make part of the users on the created shared folder, under share. thanks everybody for your input

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Accessing a file from a remote machine is done using a network share name like:

\\someCompNameorIP\shareName

When mapped to a drive letter, like "D", you can reference files within the "shareName" like

D:\subdir\myFile.xls

The full (UNC) path to this file would be:

\\someCompNameorIP\shareName\subdir\myFile.xls

In your question, you said this works:
d:\QlikView\files
but this doesn't:
\\192.168.101.130\QlikView\exempel\NyaMux5.xls

Assuming 😧 is a network drive, In your UNC form, you are missing the "ShareName" portion of the path -- whatever you used to map drive 😧
\\192.168.101.130\ShareName\QlikView\exempel\NyaMux5.xls

-Rob