Disable user to insert/delete rows , but enable data refresh

Hey all,

I have a problem with my excel file.
I have a query from sql database, from which I fetch the data. It's all good.
What I would need to do is to disable users modifying the range by adding or deleting rows in excel.
They are supposed to be doing that in the system, from where I pull the data, not in the excel file.

I can protect the sheet by allowing them all other stuff but disallowing the adding or deletion of rows.
That works...but...after this protection, my data refresh fails because of this. Because the data refresh also wants to insert or delete rows.

Is there a way around this. Disallowing users manually inserting rows , but to allow automatic data refresh to do so.

Thanks for your response,
-Jyri-

write a macro to unprotect the sheet, update and then protect it again. I have several sheets that do this and it works great.