resetting external data range in excel

[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.

 

[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.

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