Showing posts with label How-to. Show all posts
Showing posts with label How-to. Show all posts

Wednesday, May 25, 2016

How to Embed a PowerPoint deck into a Website 2016

  1. Upload your PowerPoint deck to Microsoft OneDrive for initial upload and open from there.
  2. To open in PowerPoint Online, click and select Open, or left-click to Open in PowerPoint Online

  3.  Naturally you'll want to click the Share with people(1), but the Embed option is not in the resultant window. You can share a link to other people to edit or view.

  4. Work around. You have to click Edit Presentation and choose Edit in Browser

  5. Now to get embed code goto File(1) and click Share(2) and on the Share page choose Embed(3).



  6.  The Embed page will appear with the Generate HTML code. Click Generate button.

  7. Choose the Interaction chevron to display "Use default autoadvance settings from file" to auto play the deck, if you like. This can only be set up in your PowerPoint App/Desktop. To create self-running presentation in PowerPoint refer to this Office Help link .




























    Once you happy with your options, click grab your html from the Embed Code textbox.

8. Result, familiarize yourself with the icons on the bottom "status bar" of the Excel Spreadsheet.


Saturday, May 21, 2016

How to Embed an Excel Spreadsheet into a Webpage

  1. Before you upload your Excel file do as much formatting in Excel as possible, online functionality is limited.

    Tip! Presort your table, by column before uploading. Sorting by a column online, was painful.
    Tip! For formatting online make sure your table header text fits into 1 row.

  2. Upload your Excel Spreadsheet to Microsoft OneDrive for initial upload and open from there.



    You can do it from Excel Online interface link provided at bottom left, this just saves you a step and redirects to OneDrive which can mislead you.

    Thereafter, the file will appear in your recent list for easy access.


  3.  To get embed code, you first have to Edit Workbook in

  4. You can do some mild formatting, again editing Excel Online is limited.

    Now to get get embed code you'll want to hit the Share button(1) and click Link to use to embed content and then Show embed instructions(2). Unfortunately, at the time of writing this article this was not working for me. It has been reported on Excel Online Forum.



  5. Now for the workaround. Goto File(1) and click Share(2) and on the Share page choose Embed(3).















  6.  The Embed page will appear. Customize your options.

    Tip! To get the full table to show with totals, I had to select Select a Range(2) and add the create a table reference.

    You can get the reference to your table by copying from Always start with this cell(1) and add the last cell. In image below, this is 'Sheet1'!A1, this will give you sheet name and generally defaults to 1st cell of the sheet. Double check this. Then add the last cell,  'Sheet1'!A1:H9 in this case, and describes a table of width A to H, and height 1 to 9.

    Selecting Table2 in example image below, did not show totals. I selected totals to be show under "Format as Table" office strip but this did not work.

    Once you happy with your options, click grab your Embed Code(3) textbox.




























5. Result, please note the icons on the bottom "status bar" of the Excel Spreadsheet.

View live demo of the above example, in my post Ransomware Heat Map Spring 2016.

6. Lastly, Vote for my Excel Online improvement with the folks at Microsoft. It would help!

If you uncheck "Include a download link", then you should disable "View Full-Size Workbook"(1) icon.

















Vote to prevent your source Excel Worksheet from being download.

Click link below. This improvement then makes this a true Excel viewer!

https://excel.uservoice.com/forums/274580-excel-online/suggestions/13988391--embed-if-you-uncheck-include-a-download-link