Скачать или смотреть Adding the Excel Web Access Web Part - SharePoint Tutorial

Adding the Excel Web Access Web Part is a free tutorial by Intellezy Trainers from SharePoint course
Link to this course(Special Discount):
https://www.udemy.com/course/sharepoi...
This is the best SharePoint Course
Course summary:
Add and configure sites
Create lists and libraries
Create and customize columns
Work with Document Libraries
Work with Document Library Settings
Work with SharePoint List Settings
Create Libraries and Lists, and add Web Parts
Work with permissions
Learn what's new in Office 365
English [Auto]
If your site has Excello services enabled you will be able to add the Xcel web access web part directly onto a page. This web part will allow you to show an Excel spreadsheet live on a page where people could even interact with it and refresh it for the most up to date data. Now for this to work you need to have the file saved into a Sharepoint library and you need to have Excel services installed and activated for your site I-T or the admin will take care of the access services part. You'll just need to upload the file as long as the first part is taken care of. So I've created a call center data web page and I'm going to go ahead and edit it and we'll put in this Excel web access viewer. If you go to insert and you go and click web part you'll find it in the business data section. So you can see here is Xcel web access so we clicked web part went to business data. There it is. And I click at now it's going to put this web part in. But of course nothing's going to happen because it doesn't know what you want it to show. So you can even just click here to open the tool pain or edit web part. Either way it's going to open up the web part option on the far right now for your workbook. We're going to click the little three dots which will open up a page where you're going to have to go and find your file. So I'm going to go and find my file. I know I placed it in the project x library and in the project x library there is call center data. So you just find the file you want click it. You'll see the real show up down at the bottom and you can click insert. Now as you're going through this there's a lot of settings you can apply a lot of things you can change. So at the bottom of this web part there is an apply option that you can click to get an idea of what you're looking at and you kind of see how it looks. So that's not too bad. It's not the greatest thing so far. Like it's small in a web part on the left hand side. Now it also will automatically resize. So if we wanted to kind of see what it looks like without doing anything else to it I can click OK to the web part and click save on the web page and you'll see not the end of the world but it's not too bad. You know you can move around it but of course I need more space for this to work. So I'm going to go ahead and click page at it and I'm going to edit the web part a little bit more. Now one of the things you can do is if in your Excel spreadsheet you have created a named item which is one of those named ranges or an alias you can use that up here. So I created one called chart and I could say I want you to show me chart. Now it's not too bad being see up here view suddenly we have chart as one option but we have some other things as well. So it's trying to do a little of a better job. Still not all that great but we're making it work to some extent. So you can have your web part. Use a named item if you want. Down below you'll see a whole bunch of other options. Auto generate web part title so it's auto generating. You are L as well which you click and it'll take you to the file if you want that to be turned off. We're going to go to just turn off the chrome type in a few seconds down below you also see that full toolbar and you'll see the different commands. If you don't want people to be able to open the file in Excel you just want them to look at it. You can uncheck that. If you don't want them to go to refresh connections you can uncheck that named item dropdown list. That gives us this right here so we could choose that or not. So I scroll on down you'll see navigation do I want hyperlinks to I want all workbook interactivity. You can allow people to type in Formula entry so they can actually add stuff to the sheet. Live right here. That's unchecked for pretty much a good reason. You don't want them messing with stuff. And you can turn on and off other things here. So if you want them to be able to interact with the pivot table and pivot chart that's great. They can click slicers and stuff like that if you want them to actually be able to modify the pivot table itself. You could check the button down here. So you go through and you check what you want then in appearance you can give it