I am using Excel 2003 and have 2 documents I have linked via Import External Data.

The first document has data in it and the second document is pulling the data into it to to do queries and compare this data to other data.

When I try to save the first sheet and the second sheet is open it says that it is locked becuse the second sheet is connected to it. I tried creating a macro to remove the connection after the data is pulled but it still will not save.

I need to be able to save the first document while the second is still open because other users will be using the second sheet to compare data.

Is there a way I can make the second sheet connect , get the data, and disconnect? Or can I modify the macro to do this for me?

Any help would be appreciated.

thanks
Troy