Windows Internet Options

The Excel Import functionality is only available in Internet Explorer 11 and IE mode on Microsoft Edge. Ensure that:

  1. The site is added to trusted sites
  2. ActiveX controls are enabled
  3. Access data sources across domains is enabled

The Internet Options section of Control Panel allows you to manage Internet and Internet Explorer settings for your computer. You can configure security settings and control add-ons, Active-X controls, and other components.

Adding a site to Trusted sites

  1. Type internet options in the Search box on your taskbar and choose Internet Options from the result.
  2. Navigate to the Security tab.
  3. In the Select a zone to specify its current security settings box, click Trusted Sites, and then click Sites.
  4. If you want to add sites that do not require an encrypted channel, click to clear the Require server verification (https:) for all sites in this zone check box.
  5. In the Add this Web site to the zone box, type the URL of a site that you trust, and then click Add.
  6. Repeat these steps for each site that you want to add to the zone.
  7. Click Close .
  8. Click OK to accept the changes and return to the previous screen.

Enable ActiveX Controls

  1. Type internet options in the Search box on your taskbar and choose Internet Options from the result.
  2. Navigate to the Security tab.
  3. Select Custom level, and then under ActiveX controls and plug-ins select Enable for all options.
  4. Click OK.
  5. Click Yes to confirm the changes.
  6. Click Apply to apply your changes
  7. Click OK to accept the changes and return to the previous screen.

Enable Access data sources across domains

  1. Type internet options in the Search box on your taskbar and choose Internet Options from the result.
  2. Navigate to the Security tab.
  3. Select Custom level
  4. Under Miscellaneous select the Enable option for Access data sources across domains.
  5. Click OK.
  6. Click Yes to confirm the changes.
  7. Click Apply to apply your changes
  8. Click OK to accept the changes and return to the previous screen