Publishing Your BI Tools to SharePoint - Microsoft Business Intelligence Tools for Excel Analysts - page 292

SharePoint requirements and Office 365
Excel Services is a SharePoint implementation that is available only with SharePoint 2010 or 2013, so
you'll want to ensure that your SharePoint site is one of those two versions.
You most likely work in a SharePoint 2010 or 2013 environment. However, if you don't have access to
an existing SharePoint environment, hundreds of service providers offer subscription-based
SharePoint services. Many of these providers provide volume-based pricing on a subscription model.
In fact, Microsoft offers Office 365, a cloud-based Microsoft environment that gives you a line of col-
laborative Microsoft Office-like tools that you can access through the Web. Similar to Google Docs
or Google Spreadsheets, Microsoft offers Word, Excel, and PowerPoint in Office 365. This means you
can use Office 365 to publish and host your Excel solutions.
Subscribing to a commercial SharePoint service provider may be the fastest and most affordable
way to host Microsoft Excel solutions on SharePoint. Again, the only caveat is that the commercial
service provider you choose must offer either SharePoint 2010 or 2013 with Excel Services
implemented.
Publishing an Excel Workbook
to SharePoint
In order to take advantage of the functionality afforded by Excel Services, you must have permission
to publish to a SharePoint site that is running Excel Services. You'll need to speak with your IT depart-
ment to obtain access.
When you have access to publish to SharePoint, follow these steps:
1. Choose File ➜ Save As, select Other Web Locations, and then click the Browse button.
The Save As dialog box opens, as shown in Figure 15-1.
2. Enter the URL address of your SharePoint site in the File Name box and click the Browser View
Options button.
The Browser View Options dialog box opens, as shown in Figure 15-2.
3. Select which parts of your workbook you want to make available on the Web, and then
click OK.
You can choose to show the entire workbook, only certain sheets, or only specific objects
(charts, PivotTables, and so on). You can also define parameters to allow certain named
ranges to be editable in the Web browser.