Can't update query

[Jimbola]

I have an MS Query that return some numbers for years like this;


Year 1 2 3 4 5
Dataset a b c d e

But when I change the query to display data for 2, 3, 4, 5, 6 I get the following error;

This operation is not allowed. The operation is attempting to shift cells in a table on your worksheet

If I recreate the query from start it works but it adds and additional blank row in the table, but then if I refresh the query the blank row disappears. I assume it is this adding of the blank row that is causing the error. I have tried expanding the table to include a blank row but that doesn't work either.