Recent Problem With Embedding An Excel Spreadsheet From SkyDrive

  • Author
    Posts
  • #1017383

    I recently starting having a problem when I try to embed an Excel Spreadsheet into my Word Press Blog.

    I have done this many many times, so I am very familiar with the procedure.

    What is happening now is that when I paste the Embed Code into the Word Press text editor then click “Save Draft”, the Embed Code that I pasted disappears rather than compile into shotcode. It just vanishes.

    I know what is supposed to happen is that the iframe code should be automatically converted into a shortcode, but that is not occurring.

    I have tried this on both Firefox and IE and have found the same issue.

    Additionally, I have attempted to repeat this process using existing embedded Excel spreadsheets that I know are working on older posts, but I find the same problem whenever I attempt to create a new one.

    If anyone has any insight it would be greatly appreciated.

    Thank you in advance.

    The embedded code I am pasting is as follows:

    <iframe width=”402″ height=”346″ frameborder=”0″ scrolling=”no” src=”http://skydrive.live.com/embed?cid=295D4C12045D1B7E&resid=295D4C12045D1B7E%21787&authkey=AA9H3BiFD1XT6jE&em=2&wdAllowInteractivity=False&ActiveCell=’GMS_RUNNING_TALLY’!A1&wdHideGridlines=True&wdHideHeaders=True&wdDownloadButton=True”></iframe>

    The blog I need help with is greymatterstats.wordpress.com.

    #1017485

    timethief
    Member

    iFrame codes and Javascript are restricted codes and will be stripped out to preserve security and stability on this muti-user blogging platform..
    http://en.support.wordpress.com/code/

    #1017487

    timethief
    Member
    #1017488

    Hi and thank you for getting back to me so quickly.

    Is this new?

    I have embedded Excel spreadsheets from SkyDrive many many times. Right now on our blog there are dozens.

    #1017489

    timethief
    Member

    Really! Well then forget my advice and I’ll flag this thread for a Staff response.

    #1017490

    Thank you again for being so helpful.

    Can you tell me how long it usually takes for a Staff response?

    #1017491

    timethief
    Member

    Just a minute now. I responded as if you were referring to a free hosted WordPress.com blog like http://greymatterstats.wordpress.com/

    If you were referring to http://www.greymatterstats.com/ then its not a free hosted WordPress.com blog and you need to post to http://wordpress.org/support/

    For clarity read: WordPress.com vs. WordPress.org: The Differences
    http://support.wordpress.com/com-vs-org/

    #1017562

    Hi Again,

    I am talking about our Blog site http://greymatterstats.wordpress.com/.

    #1017564

    Found the following when searching around and I believe this is the problem I am having.

    Can you shed an insight on this?

    Thanks you in advance.

    **** FOUND THIS ON WEB

    https://en.forums.wordpress.com/topic/noticed-some-changes-to-excel-web-app-that-may-need-addressing?replies=1

    Hi, you may already know about this but just giving you a heads up in case you don’t.

    Microsoft are changing Office Live documents in SkyDrive to resemble the Metro interface, they have also started offering you the option to opt in to a preview of the new Office Web Apps. I currently embed spreadsheets into my WordPress site.

    I decided to opt in and then found that any new items I went to embed simply didn’t appear. I noticed that the url Microsoft provide you with for the preview has changed and no longer starts http://r.office.microsoft.com, but starts skydrive.live.com and I think WordPress doesn’t know yet how to interpret it.

    Giving you the heads up in case this becomes a wholesale change and all of a sudden WordPress user’s can no longer embed documents/spread sheets etc.

    *****

    #1017566

    ***** I FIGURED THIS OUT *****

    For any Microsoft Live Office SkyDrive Users you need to turn off the option to “opt in” to the new version of this application.

    Once you do that, the embed code that gets generated works fine with wordpress.com.

    I assume that sooner or later Microsoft Live will be migrating completely to this new version so wordpress.com is going to need to address the change in how Microsoft is generating their IFRAME embed code.

    Thanks

    #1017736

    bravobob
    Member

    Hi,
    as Microsoft Live Office SkyDrive User I’m having the same problem to generate the right code to embed. Could you please let me know where should I turn off the “OPT IN” option ? I’m not able to find it !
    Many thanks

    #1017743

    wdtom
    Member

    I was having an operational xl application at null.
    since I needed to modify it, I generated new code at skydrive.But when tried to embed the same at wordpress.com , Iwas horrified to find that the existing xl calculator could not be embedded by wordpress.com leaving my users in lurch.
    I also find that the new code from skydrive was starting with src=”http://skydrive.live.com/embed? …….” instead of the earlier code starting with

    http://r.office.microsoft.com/…’ I feel that only on account of this I am unable to embed my calculator and other applications also that I intend to use in wordpress.com.
    Having searched the whole of internet I did neither find an alternative nor a solution to my problem.
    What I am supposed to do in the circumstances other than leaving wordpress.com.?
    regards
    wdtom

    #1017744

    bravobob
    Member

    As per my understanding problem is due to new office web apps.
    I found this workaround :
    Go to SkyDrive Option and there you need to find Office Beta Option
    Select “No Thanks” option, meaning that you don’t want use new office web apps.
    After this ,the code is generated when you embed Excel, is the same you had in the past.
    Hope it helps.

    #1017746

    jkudish
    Member

    Hi Everyone,

    Apologies about the delay here, and thank you for your patience. We’ve fixed up the Skydrive shortcode here on WordPress.com.

    The instructions on how to do the embeds has been slightly modified, so I’ve updated the Excel, and PowerPoint instructions and added instructions for Word .

    Both the old links/format and the new format will continue to work, though I suspect that Microsoft has already started deprecating the old format on their end

    Hope that helps and please let us know if there’s anything else we can do.

    #1017747

    wdtom
    Member

    Thanks all staff /jkudish
    now it works as earlier and no need to remove ‘s ‘of https:
    I have tried it with excel.
    thanks again
    regards
    wdtom

    #1017750

    bravobob
    Member

    Thanks but !
    I works only if you embed a sheet without selecting a cell range and/or without selecting a specific cell to start.
    Waiting for your help
    Thanks
    Bravobob.com

    #1017751

    jkudish
    Member

    Hi bravob,

    I’ve tried embedding just a cell range and it has worked fine for me. Can you please copy/paste the embed code that you are trying to paste into WordPress.com so that we can further troubleshoot. You can use http://pastebin.com/ to paste the snippet of code and then share the link here.

    Thanks.

    #1017752

    bravobob
    Member

    Thank you
    here it is :
    http://pastebin.com/Jbh0XdhK

    Bravobob

    #1017753

    jkudish
    Member

    Hi bravobob,

    The code you pasted is working fine for me when I try to embed it. Are you following the instructions here?

    http://en.support.wordpress.com/excel-web-app/

    If you’re still having issues, can you please specify which blog you’re trying to embed this in?

    #1017754

    bravobob
    Member

    Hi JKudish,
    thanks for your prompt reply. I’ve tested it again many times.
    While yesterday I was ready to say : “sorry it does not work” (page was blank without any Excel), today, before wasting your time, I tested it again and it works !
    Don’t ask me why. I suspect there was either a latency retriving the Excel web app or Microsoft webapp server to slow in response time. Waiting for few more seconds and it appears !
    Thank you !
    BRAVOBOB.COM

The topic ‘Recent Problem With Embedding An Excel Spreadsheet From SkyDrive’ is closed to new replies.