F
FredC
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
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