Share via

Sharepoint Online is not retaining Web Part Height setting for Embedded Excel Web Access Object

dtaraboletti 0 Reputation points
2023-06-01T17:45:17.3566667+00:00

Within Sharepoint Online, I have embedded an Excel Web Access object (Graph) which is sourced from a XLS file saved within the same Sharepoint site. The graph is appearing within the published page, but the full vertical height of the graph (object) is not being displayed.

I have gone into the Sharepoint, Edit Web Part/Appearance panel, and set the value to "Adjust Height to Fit Zone"... as shown below...

User's image

However, upon saving and publishing the page, this setting keeps reverting back to the fixed height of 400 pixels.

Has anyone experienced this problem? It clearly presents as a bug within the service.

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,953 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,536 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,708 questions
Microsoft 365 Publishing
Microsoft 365 Publishing
Microsoft 365: Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line. Publishing: The process of preparing, producing, and releasing content for distribution or sale.
599 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Haoyan Xue_MSFT 20,741 Reputation points Microsoft Vendor
    2023-06-02T02:38:08.97+00:00

    Hi @dtaraboletti ,

    From your description, you want to adjust the Excel Web Access web part height to fit the content. You set the value to "Adjust Height to Fit Zone"，but this setting keeps reverting back to the fixed height of 400 pixels.

    I could reproduce your issue in my environment.

    As a workaround, you can use CSS code to adjust the height of the Excel Web Access web part. You can add a Content Editor Web part into the page, then add this code below into the HTML source of the content editor web part:

    <style>
#WebPartWPQ2 {
    height:auto !important;
}
div[id$='sheetContentDiv']{
    height:auto !important;
}
</style>

    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.