How to move an External Query's cell 1

[rarogersonkf]

I thought this was going to be simple but I've not had any luck.

I have an external query in cell A3 and I want to move it to Cell A1.

I should think this is easily done but it's Monday morning...

Thanks in advance,

Rob

 

[SkipVought]

rob,

Select the QueryTable Name in the Name Box

Drag the entire selection (upper-LH corner) from A3 to A1.

or

Delete rows 1 & 2

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]

 

[rarogersonkf]

Thanks Skip, it did work but I didn't give you accurate information. The original cell is actually A5. Row A4... has titles for the row returned from the query. When I originally created the query I the query I chose File-->Return Data To Excel and close call A5.
When I move the query as you suggested the data is returned starting in row A1. Is there a way to then change the query (now moved to A1) to start refreshing at row A5 and leave rows A1 ~ A4 unchanged?

Thanks again,

Rob

 

[SkipVought]

do the same process -- A1 to A5

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]