Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
PROTECTING/UNPROTECTING SHEETS | Excel Discussion (Misc queries) | |||
Grouping in protected sheets | Excel Discussion (Misc queries) | |||
Multiple sheets selected | Excel Discussion (Misc queries) | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) |