Updated! Make sure your interactive embedded files really ARE interactive

Updated: See the bottom of this post for the latest Office how-tos on embedding Excel and PowerPoint files on web pages.

OK, so you read yesterday about how to embed an interactive Excel file on your web page using the Excel Office Web App to do it. But somehow, it is NOT being interactive (although it is from within the Excel program, both on the SkyDrive and on your desktop. Example: Be.ow is a debt snowball calculator. You enter each debtor, how much you owe, what the APR is, the minimum payment, etc. and Excel automatically calculates for you how long it will take to pay off the debt and how much you'll have paid total, including interest charges.

My goal for having this on my web page is so that you start, right away, on taking better charge of your finances. But, if you try to enter your OWN data...you can't:

 

I had this problem with yesterday's embedded and so-called interactive file. You can look at yesterday's comments to see what happened but I'll give it to you straight here: Once I uploaded the Excel file to my SkyDrive, when I go the embed code, it looked like this:

<iframe scrolling="no" width="500" frameborder="0" src="http://r.office.microsoft.com/r/rlidExcelEmbed?su=-5313461142353041404&amp;Fi=SDB642CB3E3234A804!129&amp;AllowInteractivity=False" height="346"></iframe>

 As you can see, the code is specifying that the viewer can't change the data. So, what needs to be added it this:

&amp;AllowInteractivity&amp;AllowTyping=True

So now, when I have the correct code in the HTML, you can change the data and customize the embedded spreadsheet to your heart's content:

And there you go. If you want to learn more about just how to embed Excel or PowerPoint files into your blogs or web pages using Office Web Apps, read yesterday's post which has all that information. Oh, and if you like the template debt calculator I used, you can find it here, on the Templates site.

New!

"As far as playing jazz, no other art form, other than conversation, can give the satisfaction of spontaneous interaction." — Stan Getz

— Crabby

Office Blogs Comments

Comments: (4) Collapse

  • I often will protect worksheets in my Excel files and unlock cells that I want to enable edits.  Will embedding Excel document honor these settings?  If not, that should be considered in future release.

  • Followed with awe at what could be achieved.

    I suppose someone has already told you of the typo in you code fix.

    Should read: &AllowInteractivity=True&AllowTyping=True

  • John Gardner: The code is correct - you can't have simply "7" in code; it must be in HTML: &

  • Microsoft wishes to develop better software out of the future.

Comments

Comments: (loading) Collapse