| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I get the message: "The External Table is not in the excpected for
I get this message when I try to refresh from a specific database file. I use
Excel 2003. The funny thing is that on another PC with Excel 2003 it works fine when I update. Can anybody tell what to do to make it work ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I get the message: "The External Table is not in the excpected for
Perhaps the PC it's not working on does not have the correct connection
settings or drivers loaded. -- Kevin Backmann "Miguel Cervera" wrote: I get this message when I try to refresh from a specific database file. I use Excel 2003. The funny thing is that on another PC with Excel 2003 it works fine when I update. Can anybody tell what to do to make it work ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I get the message: "The External Table is not in the excpected
Hi Kevin
What do mean ? Correct Connection settings ? Where can I see that ? "Kevin B" wrote: Perhaps the PC it's not working on does not have the correct connection settings or drivers loaded. -- Kevin Backmann "Miguel Cervera" wrote: I get this message when I try to refresh from a specific database file. I use Excel 2003. The funny thing is that on another PC with Excel 2003 it works fine when I update. Can anybody tell what to do to make it work ? Hi Kevin What do you mean P |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I get the message: "The External Table is not in the excpected
When you set up an MS Query in Excel the first line of business is to state
teh database source. The source could be a Database connection, or queries that you've saved to the PC or wish to create based upon one of your connections and OLAP cubes. What I would suggest is looking at the query in the original that's working and see what it's using as its data source. Then verify that the same data source is available on the second PC, the one where it's not working. -- Kevin Backmann "Miguel Cervera" wrote: Hi Kevin What do mean ? Correct Connection settings ? Where can I see that ? "Kevin B" wrote: Perhaps the PC it's not working on does not have the correct connection settings or drivers loaded. -- Kevin Backmann "Miguel Cervera" wrote: I get this message when I try to refresh from a specific database file. I use Excel 2003. The funny thing is that on another PC with Excel 2003 it works fine when I update. Can anybody tell what to do to make it work ? Hi Kevin What do you mean P |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I get the message: "The External Table is not in the excpected
Hi Kevin
How do I see my Database connections..? Is it somewhere in the control panel or is it in Excel ? And thanks a 100000 for you help... "Kevin B" wrote: When you set up an MS Query in Excel the first line of business is to state teh database source. The source could be a Database connection, or queries that you've saved to the PC or wish to create based upon one of your connections and OLAP cubes. What I would suggest is looking at the query in the original that's working and see what it's using as its data source. Then verify that the same data source is available on the second PC, the one where it's not working. -- Kevin Backmann "Miguel Cervera" wrote: Hi Kevin What do mean ? Correct Connection settings ? Where can I see that ? "Kevin B" wrote: Perhaps the PC it's not working on does not have the correct connection settings or drivers loaded. -- Kevin Backmann "Miguel Cervera" wrote: I get this message when I try to refresh from a specific database file. I use Excel 2003. The funny thing is that on another PC with Excel 2003 it works fine when I update. Can anybody tell what to do to make it work ? Hi Kevin What do you mean P |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding to excel "table" using external data query | Excel Discussion (Misc queries) | |||
| Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
| Invalid external reference message | Excel Discussion (Misc queries) | |||
| external data error message | Excel Discussion (Misc queries) | |||
| Deleted the pivot table - continue to get the "overlap" error message | Excel Discussion (Misc queries) | |||
Linear Mode
