View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default 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