When using Excel file as a datasource, if I’m using **Local** as the data route, then I have to make sure the file is located in the server, where the VDP server is running and not in any other client machine.
In case I want to use a file in some other location, I would try to use any other alternative data route, such as HTTP or FTP/SFTP or HDFS wherever possible. The manuals at [Path Types in Virtual DataPort — Virtual DataPort Administration Guide](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/path_types_in_virtual_dataport/path_types_in_virtual_dataport) and its subdirectories on the different path types would be helpful in exploring the options.
I would also refer to the KB article on using [network drives](https://community.denodo.com/kb/en/view/document/Accessing%20network%20drives%20from%20Denodo%20Virtual%20DataPort). This could come handy in case of shared excel files.
Hope this helps.