Share via

Embedded Excel (html) not editable

Anonymous
2016-12-06T20:07:19+00:00

Researching the use of embedding Excel spreadsheet into an html page (from OneDrive). I have sharing configured for everyone to be able to edit the document, however when loaded none of the cells are editable and ribbon commands are not visible. What needs to be done to make this editable?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2016-12-09T09:59:53+00:00

Hi Doug,

It is true that we cannot edit an embedded excel online workbook, which is presented through HTML iFrame.

we would appreciate your understanding.

Thanks,

Frank

Was this answer helpful?

0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-12-09T20:20:55+00:00

    Thanks Frank. One last question. Do embedded sheets have to be hosted on OneDrive/Sharepoint or could they be hosted in a location of our choosing? If they have to be hosted with MS, is there a roadmap to allow otherwise in the future?

    Doug

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-12-08T13:47:19+00:00

    Hi Qing,

    Thanks for the reply. To answer your questions:

    First 1.-4. Yes, I can see my embedded spreadsheet, click on the button you reference and edit the document in Browser. This might be a case of my not understanding the capabilities of the embedded spreadsheet. The scenario you present takes me out of the context of the page where I've embedded the spreadsheet to be edited in online Excel. Is there no way to edit the spreadsheet directly in the page where I've embedded it?

    I have a very simple test page (only contains the spreadsheet) linked to a document on OneDrive for Business.

    <!DOCTYPE html>

    <html lang="en">

    <head>

    <meta charset="UTF-8">

    <title>Test</title>

    </head>

    <body>

    <iframe width="1000" height="800" frameborder="0" src="https://sciquestonline-my.sharepoint.com/personal/dfellner_sciquestonline_onmicrosoft_com/_layouts/15/guestaccess.aspx?guestaccesstoken=ltvikrOHSbYJ77HnW0D5hlCNBL6t95WbuAfNSf9eo70%3d&docid=12f6b086bdff0471eb7980004380c2264&rev=1&action=embedview&wdDownloadButton=True">

    </body>

    </html>

    Thanks for the assistance,

    Doug

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-12-08T12:07:55+00:00

    Hi Doug,

    Are you still experiencing the issue? Let me know if I can help.

    Thanks,

    Qing

    Was this answer helpful?

    0 comments
  4. Anonymous
    2016-12-07T10:06:07+00:00

    Hi Doug,

    According to your description, I need to confirm if you have tried the following steps to edit the spreadsheet:

    1. Open the page.
    2. Click the bottom under the spreadsheet as below.

    1. Click Edit Workbook.
    2. Edit the spreadsheet in Office or in Browser.

    You also can edit the spreadsheet in OneDrive. If the spreadsheet in OneDrive has been edited, the spreadsheet in the html page would also be edited.

    If the issue still exists, please provide the following information:

    1. The steps about how you embed spreadsheet into an html page. (You can refer to the article)
    2. The screenshot of “none of the cells are editable and ribbon commands are not visible”.
    3. Where is the file stored, OneDrive or OneDrive for Business?
    4. The code which you add to the html file.

    To protect your privacy, I've sent you a private message. You can access it via private message.

    Thanks,

    Qing

    Was this answer helpful?

    0 comments