Hi
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?

On Fri, 26 Jun 2009 12:10:14 +1000, "ssdsibes"
wrote:

Hi
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?


If I am not mistaken, with a macro, you can explicitly unprotect a
sheet, call the refresh, and reprotect the sheet that contains the pivot
table or such.

I recall reading about it here (in the programming group) some
weeks/months back, but I do not recall the syntax of it.

You should ask this in m.p.e.programming, instead of
m.p.e.worksheet.functions.