Excel Power Pivot & Power Query For Dummies
Book image
Explore Book Buy On Amazon
To take advantage of the functionality afforded by Excel Services, you must have the proper permissions to publish to a SharePoint site that is running Excel Services. To obtain access, speak with your IT department.

After you have access to publish to SharePoint, follow these steps:

  1. Click the File tab on the Excel Ribbon, choose Save As→Other Web Locations, and then click the Browse button. This step opens the Save As dialog box.
  2. Enter the URL of your SharePoint site in the File Name input box.


    Enter your SharePoint URL in the input box of the Save As dialog box.

  3. Click the Browser View Options button. The Browser View Options dialog box opens.

  4. Select which parts of the workbook will be available on the web, as shown, and then click the OK button. You can choose to show the entire workbook, only certain sheets, or only specific objects (charts, and pivot tables, for example). You can also define parameters to allow certain named ranges to be editable in the web browser.

    Select which parts of your workbook will be available on the web.
  5. Click the Save button to connect to the SharePoint site and see your document library, as shown. You can think of a document library as a directory on the SharePoint site.

    Double-click the library where you want to save the file, and click the Save button.
  6. Enter a filename in the File Name input box, double-click the library where you want the file saved, and then click the Save button.
After you've published the workbook, you can view it on the web by finding the document in the appropriate library on your SharePoint site. When you open the workbook, it shows up in the browser, with several menu options, as described in the following list:
  • Edit Workbook: Either download the workbook or edit the workbook in the browser.
  • Share: Email a link to your newly published workbook.
  • Data: Refresh any external data connections that are in your workbook.
A workbook, as shown in Excel Services.

Workbooks on the web are running in an environment that is quite different from the Excel client application you have on your PC. Excel Services has limitations on the features it can render in the web browser. Some limitations exist because of security issues, and others exist simply because Excel Services hasn't yet evolved to include the broad set of features that come supplied with standard Excel.

In any case, the following list describes some limitations on Excel Services:
  • Data validation does not work on the web. This feature is simply ignored when you publish your workbook to the web.
  • No form of VBA, including a macro, runs in the Excel Web App. Your VBA procedures simply don't transfer with the workbook.
  • Worksheet protection doesn't work on the web. Instead, you need to plan for, and use, the Browser View Options dialog box.
  • Links to external workbooks no longer work after publishing to the web. Any links or references to other workbooks will no longer work after you publish your file to SharePoint.
  • You can use any pivot tables with full fidelity on the web, but you cannot create any new pivot tables while your workbook is on the web. Create any pivot tables in the Excel client on your PC before publishing on the web.
  • OfficeArt doesn't render on the web. This includes Shape objects, WordArt, SmartArt, diagrams, signature lines, and ink annotations.

About This Article

This article is from the book:

About the book author:

Michael Alexander is a senior consultant at Slalom Consulting with more than 15 years’ experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel, and has been named Microsoft Excel MVP for his contributions to the Excel community.

This article can be found in the category: