View Single Post
  #1   Report Post  
ajf
 
Posts: n/a
Default 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.