Doing this can avoid confusion later, especially if you want to display a single item in a SharePoint Web Part (instead of displaying the whole workbook in the Web Part). However, as a best practice, we recommend that you define named items in Excel. Define named items in a workbookĭefining named items is not an absolute requirement for sharing a workbook by using Excel Services.
How to share excel spreadsheets online how to#
The following sections describe how to perform the steps to share a workbook by using Excel Services. (This is optional.) Display all or part of an Excel workbook in an Excel Web Access Web Part. Ideally, you'll use a library such as a Document library in a Business Intelligence Center site. Publish the workbook to a SharePoint library. You can choose between worksheet view or gallery view. These items can be charts, tables, PivotChart reports, PivotTable reports, ranges of data, and so on.Ĭhoose browser view options for the workbook.
Excel Services enables you to do this by following a simple process:ĭefine one or more named items in the workbook. Suppose additionally that you might want to display some content in that workbook in multiple locations. Suppose that you have created an Excel workbook that contains info that you want to share with others.
How to share excel spreadsheets online install#
For more info, see Install SQL Server BI Features with SharePoint 2013 (SQL Server 2012 SP1).
If you plan to publish a workbook that contains a Power View sheet, SQL Server Reporting Services must be configured in SharePoint integrated mode. For more info, see Configure Excel Services in SharePoint Server 2013 Preview. If you plan to publish workbooks that contain data models to SharePoint Server 2013, Excel Services must be configured to support data models. You should have already created an Excel workbook that contains at least one item, such as a chart, table, PivotChart report, PivotTable report, or range of data. You must have at least Contribute permissions assigned to you for the SharePoint library where you plan to publish the workbook. This can affect how you connect to different data sources. You will need info from a SharePoint admin about how data authentication is configured for the databases your organization uses.
/001-how-to-unprotect-excel-workbooks-4691837-3a97c2e1474c45e8a6a8175b2222307a.jpg "how to share excel spreadsheets online")
For more info, see Configure a Business Intelligence Center in SharePoint Server 2013. Ideally, you'll have a Business Intelligence Center site configured that you can use for your data connections and workbooks. You must be using Excel and SharePoint Server 2013.Įxcel Services must be configured to include a trusted data connections library and a trusted document library. Specify how you want a workbook to be displayedĭisplay Excel content in an Excel Web Access Web Partīefore you begin this task, review the following info about prerequisites: To learn how to share workbooks using Excel Services, see this article. You can also choose to display Excel content in a special SharePoint Web Part known as the Excel Web Access Web Part. When you publish a workbook to SharePoint Server 2013, you can choose between several browser view options (such as worksheet view and gallery view). APPLIES TO: 2013 2016 2019 Subscription Edition SharePoint in Microsoft 365Įxcel Services in SharePoint Server 2013 enables you to share all or parts of an Excel workbook with other people in a central location.
0 kommentar(er)
