'only created connection' grayed out

W

wilson

How can I create a connection to a Access 2007 query in Excel 2007 without
creating any kind of table so I can use subtotal? The import data dialog box
has 'Only Create Connection' grayed out. It will only allow some type of
Excel table to be imported and that makes subtotal unavailable. I've tried
importing several ways. I do not want to convert to a range because I need to
be able to refresh the data often.
 

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

Top