About accessing a data source on a different domain

Office PivotTable

When a PivotTable list attempts to access data on another domain, it might fail due to one of the following reasons:

  • The site being accessed by the control is not included in the list of trusted sites.
  • In Internet Explorer, on the Security Settings dialog box, under Miscellaneous, Access data sources across domains is either set to Disable, or set to Prompt and when prompted, you clicked Cancel.

To enable access across domains, do the following:

ShowEnable prompting

ShowAdd the site to the list of trusted sites