Can't open excel files withQlikView

[#1]

Hi

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

[#2]

It could be many things. What are you doing? What's the error?

[#3]

when i run the script i get an error message that says that the files can't be opened. i'm trying to get data from the excel files. i've checked the path and it's correct, the files aren't protected or read only or anything either

[#4]

What is the specific error message? I've had several variations on this over the years. Sometimes it is an invalid file format. Sometimes the file is locked open by Excel. It depends.

[#5]

Hi,

Check the file access permissions... The file must have read write permissions.

Thanks,

Saran.

[#6]

@Jay Jakovski

The file can't be opened '192.168...xls'...

(it's swedish so I translated it, beware that it might not be the exact message)

[#7]

Can you paste the section of script that loads from the file?

[#8]

NyaMux: Load Postnummer AS #PostNummer, [Nya Mux 5] AS sls_Nya_Mux_5 FROM \\192.168.101.130\QlikView\exempel\NyaMux5.xls] (biff, embedded labels, table is [Mux$]);

if I change the Ip to "D:" it works, but I would like to use the ip and that doesn't seem to work

[Anonymous]

I'm not sure whether this is just a character that was cut in the copy / paste.. but you seem to be missing the first [ - bracket before the \\ in the example above.

[#10]

it's a copy/paste fail