Remove ribbon and tabs from editable Excel sheet embedded into SP page

KellerAndrew-3552 0 Reputation points
2024-02-09T21:23:47.8833333+00:00

I'm trying to embed an editable Excel sheet into a SharePoint page, but only want users to see the sheet itself (no tabs, no ribbons). I'm using the iframe parameter action=edit to make it an editable sheet, which works. I'm encountering the following issues, though:

  1. I'm trying to use wdHideSheetTabs=True, but it seems to only work when the sheet is NOT editable. Is there another parameter/workaround that will remove the tabs?
  2. There doesn't seem to be a parameter that removes the ribbon...I tried ui=none but it didn't affect any change.

Am I using the wrong command for the action parameter? If not, are there solutions to the issues above?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,156 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Du-MSFT 39,366 Reputation points Microsoft Vendor
    2024-02-12T08:48:22.8433333+00:00

    Per my test, I could reproduce the situation as you described above.

    The parament wdHideSheetTabs=True only works with action=embedview, it cannot work with action=edit.

    The only workaround is select Show tabs only in the excel file.

    enter image description here

    Reference:

    https://support.microsoft.com/en-us/office/show-or-hide-the-ribbon-in-office-d946b26e-0c8c-402d-a0f7-c6efa296b527#ID0EBBD=Newer_Versions


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.