External Data and Sheet Protection

  • Thread starter Thread starter nbs
  • Start date Start date
N

nbs

I have a sheet that runs automatic external web and
database queries...I need to protect the sheet from user
changes but when I do the automatic updates are not
permitted either. Is there a way to permit auto updates
and prevent user changes a the same time? THANKS.
 
Untested:

Maybe you could have your query put its data in another sheet (hidden, but
unprotected).

Then use formulas to return the values to the user's worksheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top