Worksheet Protection and Refresh External Data

S

ssdsibes

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet protection 1
Protected Sheet and allowing External Data Refresh 2
excel external data range "failed to refresh" 0
excel external data range failed to refresh - second try 1
XL2007: Protection and Name Manager? 1
Embed the same Excel multiple times 0
Automatically Scheduled Task with Start on Constraint and Neg Slack 0
External Data wont refresh on a prtected and shared workbook... 0

Top