SharePoint 2016 - How to erase the toolbar in a Embed Excel

Article
2019-10-31

Question

_{Thursday, October 31, 2019 1:22 PM}

Hi! I´m using SharePoint and have a problem with an embed Excel. Does anybody know how to erase the toolbar in an embed Excel Range? The problem is that I dont want the users have access to the workbook. Or at least not to all the sheets.

All replies (2)

_{Friday, November 1, 2019 2:55 AM}

Hi NicCarr,

To hide the sheet in the Embed Excel, you could add “wdHideSheetTabs=True” behind the item URL.

To erase the bottom bar, since this worksheet is loaded from OneDrive, for security reasons, we cannot modify the iframe.

As a workaround, we could use CSS to cover the bottom bar, we can add a container/wrapper around the iframe, and add CSS as below:

<div class="wrapper">
    <div class="hideBottom"></div>
<iframe width="1000" height="500" frameborder="0" scrolling="no" src="https://XXXX&action=embedview"></iframe>
</div>

<style>
.wrapper{
    ;
    z-index: 1;
    display: inline-block;
}

.hideBottom{
    ;
    width: 1000px;
    height: 30px;
    background: #222;
    right: 0px;
    bottom: 6px;
    z-index:999;
    display: block;
    color: #fff;
}
</style>

Insert the script in the Script Editor web part and adjust “width” and “height” property in the CSS for your requirement.

Best regards,

Grace Wang

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

SharePoint Server 2019 has been released, you can click

here to download it.
Click

here to learn new features. Visit the dedicated

forum to share, explore and talk to experts about SharePoint Server 2019.

_{Friday, November 8, 2019 7:12 AM}