if the refresh is forced by a macro (ie VBA) you could possibly unprotect
the sheet before refreshing then protect it again afterwards?


"ssdsibes" wrote in message
...
Hi
I posted this in PE Worksheets, but was advised to try here.

here is my query.

I have protected my worksheet to stop users from chaning information, but
now the Refesh External Data does not run.
I need to unlock the worksheet to run it, but i don't want the users to do
this.

Is there a way to enable the refresh data while the worksheet is still
protected?