Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'only created connection' grayed out
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. -- wilson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
always recheck data connection library for latest connection strin | Excel Discussion (Misc queries) | |||
no DDE connection?? | Excel Discussion (Misc queries) | |||
Help with connection macro? | Excel Discussion (Misc queries) | |||
Connection error | Excel Discussion (Misc queries) | |||
Changing OLE DB connection | Excel Discussion (Misc queries) |