Hello,

I have a web query updated one cell, with the query property set so that the cell updates when file is opened. The cell is unlocked.

I turn file protection on, then save and close the file. When the file reopens, the following pop-up warning appears:

"The cell or chart that you are trying to change is protected and therefore read only", along with instructions as to how to unlock the sheet.

It then displays another popup, with a message stating, "The following data range failed to refresh:" along with the website address being used in the query.

The query update fires some VBA code:

Please Login or Register  to view this content.
I've even tried unlocked cell CR7, realizing later that the error is being thrown before the VBA code is even being called.

Any ideas as to how to get the query to run, or why the cell is being treated as if it's locked when it's not? I'm stumped.