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

Question

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

dtaraboletti 0

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.

1 answer

Your answer

Answer 1

Xyza Xue_MSFT 30,176 Microsoft External Staff

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.

dtaraboletti 0 Reputation points

2023-06-02T13:42:25.33+00:00

I see where you're going with this... but admittedly, I'm more of a superuser than developer.

Researching the use of the content editor webpart via other sites, I have added the content editor webpart. Created a Site Asset File containing your CSS code...and linked the Content Editor Webpart to that file. I've tried multiple variations of this and it's still not working. @Xyza Xue_MSFT Can you please provide more explicit instructions?
dtaraboletti 0 Reputation points

2023-06-02T13:44:26.07+00:00

Also... please note that within the page HTML code...the Height setting for the webpart appears to be set to dynamic (rather than fixed) height.

WebPart="true" Height="" Width=""></WpNs0:ExcelWebRenderer>
Xyza Xue_MSFT 30,176 Reputation points Microsoft External Staff

2023-06-06T08:15:40.48+00:00

Hi, according to the description in your original post, you want to set the height to "Adjust Height to Fit Zone", which is similar to automatically adapting to the height. Now you want to set the height to be fixed, right?

Maybe you can try to set a fixed height directly on the setting page?
dtaraboletti 0 Reputation points

2023-06-06T15:14:51.9466667+00:00

@Xyza Xue_MSFT Sorry if I was unclear. 1) I WANT the object to automatically set height. 2) The Sharepoint solution is NOT RETAINING this setting. 3) Sharepoint reverts to the default height of 400 pixels. 4) Sharepoint is allowing me to set a fixed height on this and other controls...but that is NOT the desired behavior.
Xyza Xue_MSFT 30,176 Reputation points Microsoft External Staff

2023-06-09T09:07:23.62+00:00

You have tried setting the value to "Adjust Height to Fit Zone" in the SharePoint Edit Web Part/Appearance panel, but the setting keeps reverting back to the fixed height of 400 pixels upon saving and publishing the page.

This issue has been reported before and is a known bug in the service. I was testing in my environment and wanted to make the height automatic by adding CSS code. But it doesn't seem to work either. In view of the complexity of this problem, I suggest you make a service request in M365 admin center.
dtaraboletti 0 Reputation points

2023-06-13T17:21:10.4566667+00:00

Thank you... I raised a ticket about a month ago. Microsoft Support has not been able to provide assistance. Most recently, they indicate that this feature is being deprecated, along with classic page deprecation. The do not seem to be interested in resolving this obvious bug.

Share via

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

1 answer

Your answer