Excel 2007 data connection

K

Kurt Barr

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?
 
K

Kurt Barr

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Switching ODBC sources in Excel 2007 1
2007 Pivot Tbl to Access Conversion Issues 6
2007 Pivot to Access 1
How do I connect to access 2007 data from excel? 3
ODC properties: OLAP Server Formatting 0
Removing DATA Connections 1
Excel Error while connecting to OLAP cube 0
View Pivot Table Source data as a Data Table 6

Top