| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet protect with query-based table
I have a table with 3 columns based on a SQL db query, with a worksheet
column added to the table that is a formula I want to protect. There are 3 other non-table cells I want to protect. If I protect the worksheet, I can't refresh the table, even if I unlocked the table cells that are based on the query. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to partially protect a pivot table based worksheet | Excel Discussion (Misc queries) | |||
| Finding the Access query a pivot table is based on | Excel Discussion (Misc queries) | |||
| protect query from edit | Setting up and Configuration of Excel | |||
| how to protect worksheet from edit my query | Excel Discussion (Misc queries) | |||
| How to protect the query use for a Pivot that uses 'Get External D | Excel Discussion (Misc queries) | |||
Linear Mode
