• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

Set the ask to update external links option programatically

I am creating a installer for an excel addin and need to be able to turn the "ask to update automatick links" option to on as part of the install is this a registry setting?



0
JonMny
Asked:
JonMny
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
The key name is:

   HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options

Where 11.0 is the Excel version.

The value name is:

   Options5

It's a REG_DWORD and it's the 14th bit. Use this mask to set it: 0x00004000.

Kevin
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now