Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query Into Protected Sheet - Excel 2000 on WinXP Home (SR2)
I am using a Saved Query (.iqy) to
update a single range from a website, which works well. It executes when the workbook is opened. Formulas on a protected second sheet in the workbook display a re-formatted version of the data from the sheet being updated. The external data range, and multiple rows and columns around it on the query sheet, are all un-locked, but if I protect the query sheet, a message appears when the workbook is opened, saying "The cell or chart you are trying to change is protected and therefore read-only". How can I make the query work without the error, but retain the protection for the remainder of the sheet being updated? - Fred |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ctrl Home disabled in protected worksheets | Excel Discussion (Misc queries) | |||
Ctrl+Home failure when sheet protected | Excel Discussion (Misc queries) | |||
xyScatterChart macro works on WinXP Pro & not on WinXP Home? | Excel Discussion (Misc queries) | |||
PrintOut_Method Outputs (Win 2000 Pro and XP Home) | Excel Programming | |||
Refreshing an external query on a protected sheet | Excel Programming |