View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pablo pablo is offline
external usenet poster
 
Posts: 76
Default Importing External Data Locks Source Workbook

I have imported external data from one workbook to another. Everytime I
refresh the data, no one can open the source file. Is there anyway to
disconnect the ole db query or create something on vb to disconnect it.
I am in a network environment and need other people to be able to access the
file even if I refresh.
Thank you