The spreadsheet attempted to access data on another domain, but failed 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:
- In Internet Explorer, on the Tools menu, click Internet Options. On the Security tab, select the appropriate Web content zone, and click Custom Level. Under Miscellaneous, set Access data sources across domains to Prompt.
- When prompted, if you trust the data provider, click OK to allow the PivotTable list to access data from the specified domain.
Add the site to the list of trusted sites
If the site being accessed is always trustworthy, add the site to the list of trusted sites.
- In Internet Explorer, on the Tools menu, click Internet Options. On the Security tab, select Trusted sites as the Web content zone, and click Sites.
- In the Trusted sites dialog box, enter the site details, and click OK.