Debugging VSTO startup issues

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.

Still need help? Contact Us Contact Us