We have few xlsx files (data files) in our SharePoint location. I tried loading those files by using Data From Files > Web Files (i gave the SharePoint http URL) wizard but the file loading failed. (It gave some zip error in the wizard's panel)
Any idea how to read or load xlsx files from SharePoint Server to QV (ver 10) ? Please Advice ?
The particular sharepoint where I am going to fetch the data needs authentication. Could you please let me how that can be done please.
Created the new thread for the same below.