Need help to connect your data! ๐Ÿ‘‹ Get in touch

Additional menu

Debugging VSTO startup issues

โ† All Topics

In certain cases, Data Everywhere support needs more information to debug issues within the Excel Add-In.

A framework we use, Visual Studio Tools for Office (VSTO), can display errors in a message box which are helpful for troubleshooting. To enable or disable this logging, the user needs to adjust Windows environment variables.

Instructions for Windows 7 and Windows 8/8.1 are provided here.

Windows 7

  1. Click the start menu, then right click on “Computer” and choose “Properties”.
  2. Click “Advanced system settings” in the left hand navigation.
  3. Click “Environment Variables…” at the bottom of the dialog.
  4. Under the “User variables for…” section, click “New…”.
  5. For “Variable name”, use “VSTO_SUPPRESSDISPLAYALERTS” (without quotes). For “Variable value”, use “0” (without quotes, a single ‘zero’). Click “OK”.
  6. Confirm that the new variable is present in the dialog box.

For these changes to take effect, you will need to restart Microsoft Excel. Additionally, you may need to re-enable the Data Everywhere add-in; see the related articles below for instructions on how to do this.

Windows 8/8.1

  1. Click the Windows key on your keyboard key to activate Search.
  2. Type “environment” (without the quotes).
  3. Click the “Edit environment variables for your account” search result.
  4. Follow the Windows 7 instructions above from Step 4.

For these changes to take effect, you will need to restart Microsoft Excel. Additionally, you may need to re-enable the Data Everywhere add-in; see the related articles below for instructions on how to do this.