refresh external data on a protected sheet
I have a worksheet that has an external data area and some other sections
that need to be protected. I have unlocked all the columns used by the
external data. When I protect the sheet, I can no longer refresh the external
data area. Even if the entire worksheet is unlocked, the Refresh button is
unavailable.
|