Hi,
I'm trying to make Excel sheet updating from external Excel file.
I'm using Data > Get External Data > Other Sources > Microsoft Query > Excel files
From here I can get the external data when the Excel file (containing the external data) is on a drive recognized by the computer (e.g. C: ).
But when I'm trying to get Excel file from the Internet, it does not work.
For example, my file 'example.xlsx' is located in
ftp://100.101.102.103
I tried to select 'Network' in the Query option, making all the necessary operations, but it does not work.
Anyone has an idea ?
Thanks,
Haim
Bookmarks