In Excel 97 with MS Query, I want to make a query of a file I keep in a directory network called "Y:xxx"

I am working in "book1.xls". I use the menu DataGet external dataRun a new Query. After selecting the file, when I click the "connect" button, I get the error message "Data Truncated" and cannot proceed.

After several negative attempts (which included re-installing .xls OBDC driver) I copied the excel database from Y: to C: (my PC). And it worked.

While this can be a solution, I dont want to duplicate files in different places of the network. Does anyone know how to overcome this problem?

Thank you