<div>
<blockquote>
How can I prevent users from accessing these options on the data menu? 
</blockquote>
<br />
I got something similar too.<br />
<br />
But I ended up using macro to refresh the connections. And replace it with &quot;Dummy&quot; connection properties once the refreshing is done. So that when user wants to manual refresh it, it will prompt error and cannot be proceed.<br />
<br />
Hope that make sense
</div>


> How can I prevent users from accessing these options on the data menu?


I got something similar too.

But I ended up using macro to refresh the connections. And replace it with "Dummy" connection properties once the refreshing is done. So that when user wants to manual refresh it, it will prompt error and cannot be proceed.

Hope that make sense

Director of Information Technology

Lawrence Salvucci

<div>
<div class="content wysiwyg-content">
I have a workbook that is shared by multiple users and I want to lock down access to the &quot;Connection Properties&quot; and the &quot;Refresh All&quot; buttons on the Data menu. I have the worksheet password protected but those two options are not grayed out when I protect the worksheet. Should they be? The &quot;Queries &amp;&nbsp;Connections&quot; is also accessible even when I password protect the worksheet. How can I prevent users from accessing these options on the data menu?
</div>
</div>


I have a workbook that is shared by multiple users and I want to lock down access to the "Connection Properties" and the "Refresh All" buttons on the Data menu. I have the worksheet password protected but those two options are not grayed out when I protect the worksheet. Should they be? The "Queries & Connections" is also accessible even when I password protect the worksheet. How can I prevent users from accessing these options on the data menu?

Preventing Users from opening Connection Properties &amp; Refresh All in Excel Menu

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Preventing Users from opening Connection Properties &amp; Refresh All in Excel Menu

Preventing Users from opening Connection Properties & Refresh All in Excel Menu