Layout/Formatting problems of Data Queries in Excel?
 

I am using Excel 2003 to display a simple table result from an Access 2003
table.

1. When I select a cell location for a Data Query in the XL spreadsheet,
Excel moves all text, above or below that cell, to adjacent columns to the
right of the selected cell. (Also, there is no undo option and it all has to
be manually restored!)

2. In 'Data Range Properties', the option: 'Insert entire rows for new
data, clear unused cellls' is selected. Despite this, the data is displayed
with only cells inserted, not entire rows, rendering my report useless.