If you want to use Excel Services on the demo VM (AX-SRV-01) and you are getting the message “The File Cannot be saved to this location because there is no connection to the server”. Then these steps will help
Type CMD, Press Enter
In the command prompt window type “net stop sens” and press enter.
You should get a message like this :
This will let you use the Save As Option in Excel to to type in the File Name box e.g., http://sharepoint/EP
This will give you a list of document libraries. The click on Analysis Reports and save into this document library or create a new one your self to store the different document libraries.
You can also type the document library URL directly into the File Name box. e.g. :
Or also use the Publish to Excel Services button
This video will walk you through an example of Excel Services
(Original post at http://blogs.msdn.com/lcash)