View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kurt Barr Kurt Barr is offline
external usenet poster
 
Posts: 25
Default Excel 2007 data connection

I've set up a connection to an Access DB to pull data over for my worksheet.
Once the connection is made, and the data is over, I can no longer open the
file if I'm not connected to the network.

Is there some setting that I'm just not seeing where I have to set it to
cache the results?