ExcelBanter - Excel 2007 data connection

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel 2007 data connection (https://www.excelbanter.com/excel-discussion-misc-queries/258414-excel-2007-data-connection.html)

Kurt Barr

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?

Kurt Barr

Excel 2007 data connection

Please ignore this question. I've figured out why I couldn't open the file
like I wanted to.

All times are GMT +1. The time now is 02:03 AM.