[Solved] Cell Protection following Data Refresh

[beersuser]

I have a spreadsheet containing 3 elements:

• A formula that i want to protect.
  A data range that is pulled from a SQL database.
  A Button that calls a Macro to refresh said data.

I have unprotected the whole sheet, except for the cell containing the formula.

When I refresh the data range for the first time (either via the Macro or via Data > Refresh range), the data that is pulled in is automatically set to protected.

Subsequent attempts to update the data result in a 'Protected cells can not be modified' message.

Is there a way to ensure the data being pulled in is not automatically protected?

Best regards

[Villeroy]

menu:Data>Define...
select the database range in question
Click >Options
Check "Insert or delete cells". This makes sure that refreshed database ranges insert new cells as they grow and remove cells as they shrink. IMHO, this option is obsolete because it makes no sense to not set it. Same with option "Keep formatting" which refers to the formatting of the spreadsheet. You always want to keep any formatting of the output document.

[beersuser]

Thanks - worked a treat!