resetting external data range in excel

G

Gwen

I am needing to reset the external data range in a
worksheet. When I try to pull in data from excel to word
using ms query, I only see half of the colums because the
external data range does not include all of the columns.
 
J

Jonathan Rynd

I am needing to reset the external data range in a
worksheet. When I try to pull in data from excel to word
using ms query, I only see half of the colums because the
external data range does not include all of the columns.
Click to expand...

If you show the External Data toolbar, there is a button on it to edit the
current query.
 
Top