You can also use this parameter to define the active sheet by selecting a cell in that sheet. You can specify the active cell by cell reference (such as A1) or by name. Specifies the active (selected) cell in the embedded workbook when the web page opens. If your workbook includes a chart, table, PivotTable, or named range, and you want to display only one of the items in your web page, use the Item parameter to specify that item. Lets you interact with the data if your workbook has a table or PivotTable that can be sorted and filtered.ĭisplays a specific item. Hides the sheet tabs that are displayed at the bottom of all sheets in a workbook. You can also control how the dashboard appears with the following parameters which get appended to the end of the URL with an ampersand: URL Parameter We can add further parameters to the iframe that control how the dashboard is displayed in the web page.įor example, with the following additions you can specify the iframe size in pixels to suit your dashboard so there are no scroll bars: Dashboard Presentation Parameters To use this link in a web page you need to wrap it in iframe HTML tags like so: Iframe Size Parameters It should look something like this: Embed Code Once you’ve chosen the settings, click Apply and then copy the link: TIP: If you want to prevent the workbook from being downloaded, check the ‘block download’ button in Other Settings (3).

If so, you will need to consult your administrator.

It’s possible that your SharePoint admin has blocked the option to allow anyone with the link to view the workbook. IMPORTANT: If you’re embedding the workbook in a web page, then you’ll want to set the permissions to ‘Anyone with the link’ (2). My default is ‘anyone with the link can view’ but yours might be different:

Next, click on the default setting (1) to customise the link. Locate your file on OneDrive for Business or SharePoint and click the Share icon: OneDrive for Business or SharePoint Process

Excel for Decision Making Under Uncertainty CourseĮmbedding Excel Dashboards in a Web Page - Written Instructionsįirst, I recommend that you define a name for the cells containing the dashboard in your workbook as this will enable you to specify just that cell range to be displayed in the web page.

Excel for Customer Service Professionals.

Excel web