Error on sharing an external data connection

Hi,

I have a file with a data connection to another excel file and it works ok if the 2nd file is closed. If I open the 2nd excel file and I try to use the data connection in the fisrt file I get the message "the connection for viewing your excel worksheet was lost". If I open the first file and then I try to open the 2nd one I get the message "... file currently in use. Try again later".

I have changed the Mode in the connection string to Mode=Read, but It changes to "Share Deny Write".

What can I do to be able to work with both files at the same time?


Regards,
Elio Fernandes