Avatar of Jiya Patel
Jiya Patel
 asked on

How to remove scroll bar from excel web access web part in sharepoint 2013?

Experts,

 We have sharepoint 2013 and we created the dashboard in excel and displaying with excel web services. We want this web page look like dashboard. We want to hide or get rid off scroll bar from web part.
Microsoft ExcelMicrosoft OfficeMicrosoft SharePoint

Avatar of undefined
Last Comment
Shums Faruk

8/22/2022 - Mon
Shums Faruk

To accomplish the above, you have to do two things.
1. In Dashboard Designer, set the sizing of your Excel report to auto.
2. This is what got me: published PivotCharts and PivotTables should not be on a dedicated sheet in Excel. Published PivotCharts and PivotTables should not be on a dedicated sheet in Excel. They must be embedded as an object within a spreadsheet.
If you continue to experience scroll bars, resize your chart within Excel and republish. From there, you may need to modify the size of your web part in its properties.
Another approach would be try below article and include that script to fix this
https://www.nothingbutsharepoint.com/2009/01/05/jquery-for-everyone-dynamically-sizing-excel-web-parts-aspx/

Hope this helps.
Jiya Patel

ASKER
Hi,
 https://www.nothingbutsharepoint.com/2009/01/05/jquery-for-everyone-dynamically-sizing-excel-web-parts-aspx

  I can see some script here, If I add this script to the page by scipt editor , scroll bar dis appear ?  any another steps I need to take care?
Jiya Patel

ASKER
Hi,
 
  It's not working. Did you try by yourself ? Please advice.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ASKER CERTIFIED SOLUTION
Shums Faruk

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.