| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
| Merger Two Data Sheet | Excel Discussion (Misc queries) | |||
| Prompting to allow External Query Data Refresh | Excel Discussion (Misc queries) | |||
| Glue/Lock cells to external data before refresh | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
