| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Arvi Laanemets wrote:
You must define your source table as non-dynamic named range Or in the table options, check 'system tables' and the worksheet names will be available. Or just type the SQL in, using the sheet name or range address e.g. SELECT MyCol FROM [Sheet1$]; Jamie. -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Charting Data from Excel | Charts and Charting in Excel | |||
| multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
| Layout/Formatting problems of Data Queries in Excel? | Excel Discussion (Misc queries) | |||
| Refreshing Access data in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
