I've started experimenting with the rather cool technique of using Data
Import to get data from another spreadsheet. This is better than linking to
the other spreadsheet, because the other spreadsheet doesn't need to be open,
and I can easily grab large chunks of data.

Setting up the link for the first time I use the "Data : Get External
Data"menu. This sets up the Connection string, Command type, and Command
text. I found that I can change the Command type from Table to SQL, then I
can actually use SQL commands to filter and choose fields, do calcs, etc. I
can also use code to externalize the spreadsheet to use, destination range,
etc.

This is really useful, except I've run into one problem.
Once I've run the Data Import, the source workbook is now locked. ie. if I
open it, I get a "Locked by another user (me)" message and it won't unlock
until I close the destination workbook.

There is a piece of the connection string that looks like this:
Mode=Share Deny Write;
This might be the culprit, but I can't find a list of other options anywhere
in the help.

Help?
Thanks