Microsoft Office Tutorials and References
In Depth Information
Chapter 9: Sharing Workbooks with the Browser
Publish a workbook that contains external data queries that cannot be refreshed on the server
Use offline editing options and the server draft location when publishing a workbook
Excel Services can only load files from locations it has access to and that are defined as trusted locations.
If you attempt to publish a workbook locally to your My Documents folder or to your desktop with the
Open in Excel Services option selected, the browser window opens, but Excel Services fails to load the
workbook. This is because, in most cases, the server does not have access to your local directories, nor
are they defined as trusted locations. The error message shown in Figure 9-9 is displayed.
The simple remedy is to verify that the location to which you are publishing the workbook is, in fact,
defined as a trusted location on Excel Services. Chapter 8 provides more information.