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

KellerAndrew-3552 0 Reputation points

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?

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

    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


    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.