If you plan to create more ranges for implementation throughout SharePoint, the key is remembering what you named the range. In my case I use Dashboard if only one Excel range will be used. The name manager is most helpful when modifying or removing existing ranges. You can also create ranges using the Name Manager. Once you have the area selected, choose the FORMULAS tab and click Define Name.
In my case, I am highlighting the A1 through M39 range. Highlight the cells you want to include in your web part. Our first step is to create a named range. While other options were sometimes brought up, the named range option has worked as expected. By using Named Ranges in Excel we can hide scrollbars. We made this change, but the scroll bars did not go away.Īfter doing a lot of searching online, I came across this option. Here we can adjust the size in appearance. We will skip the Navigation options and check out the next two sections – Appearance and Layout. We had navigation only turned on, but have now changed it to None. In our view there is no recognizable or relevant changes. In the first group of settings, we can hide the toolbar.
The first place to look to solve this issue is in the web part properties. When deployed as an entire workbook, you will see the tabs at the bottom and the vertical and horizontal scrollbars. Here is the example I use based on the MyVote application analytics. This is easily done by editing your dashboard page and adding the Excel Services web part.
In SharePoint and Office365, we have the ability to add Excel dashboards we have created to our BI site. Enjoy! The Issue – Scrollbars in Excel Services Web Part I hope you too will discover something new you can use. In order to not forget what I learn or discover, I write it down … here.
Much of the content will be a result of my daily interactions with business users and other BI devs. As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later.
0 kommentar(er)
