I'm having trouble getting my spreadsheet to retain it's formatting.

Even though I have selected the option 'Insert entire rows for new data,
clear unused cells' no new cells are being inserted.

I have a series of totals and subtotals underneath the returned data and
don't want to have to reformat the spreadsheet everytime I refresh the query.

How can I prevent the new data over writing th ecells beneath it?

See example below:

Before

Data1 Value1 Value1A
Data2 Value2 Value2A
Empty Row
Empty Row
Empty Row
Totals and lots of cell formatting


After

Data1 Value1 Value1A
Data2 Value2 Value2A
New1 New1 New1
New2 New2 New2
Empty Row
Totals and Lots of Formatting

Why doesn't it do what it says it will and insert new rows within the
spreadsheet to host the new data?