What’s missing from these options is the ability to select a sheet to display within the web part. In my example I wanted to embed the same spreadsheet, but displaying different sheets in each embedded “view” of the Excel file. There is quite a lot of information around how to this online, but I found that none of the answers worked within the context of the File and Media or Embed web part.

Solution

Here’s how I approached it: