View Single Post
  #1   Report Post  
Excel GuRu
 
Posts: n/a
Default Protected Sheets or other security

Using excel, I have a ODBC connection and have a query set up that I would
like to be refreshed by sales people regularly, when they choose to. I would
prefer for security reasons that they cannot edit the query, only refresh the
query. The data is summarized in multiple pivot tables. I

s there a way to accomplish this by protecting the sheet that contains the
query? Or is there another option? Even if we establish Oracle security at
the database level, the query could still be edited. We'd prefer that they
don't edit the query.