We help IT Professionals succeed at work.

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

Lawrence Salvucci
Lawrence Salvucci asked
on
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?
Comment
Watch Question

View Solution Only

Ryan ChongSoftware Tead Lead / Business Analyst / System Analyst / Data Engineer
CERTIFIED EXPERT

Commented:
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
Commented:
I just customized the ribbon to remove access to the queries and connections.