Power View In Excel 13 Part 3
In the past two posts I mentioned how to create a Power View Report in Excel 13. In this post I will mention some issues that we might come across when we try to create a Report with the use of Power View.
When we want to add some more data to the Power View Sheet, all we have to do is to select the data and then from the Insert tab we select the command Power View from the area of the ribbon named Reports. Once selected the Insert Power View dialog box appears as shown in the image below.
In this dialog box we have two choices to select from:
Create a Power View Sheet: We use this command if we want to create a Power View Report from the beginning.
Add Selected Data To An Existing Power View Sheet: In this case if we want to add data to an existing Power View Sheet we select the arrow at the right of the command Location as shown in the image below. Once selected the drop down menu appears with all the existing Power View Sheets that we have in our workbook and just select the one that we want to add the data to.
In the case that the data that we have selected and that not is valid and we want to create a Power View Sheet then a Microsoft Excel warning dialog box appears mentioning the following:
The Power View Field Name Is Not Valid. To Create A Power View Report, Use Data That Is Organized As A List With Labeled Columns. If You Change The Name Of A Power View Field, Type A New Name For The Field.
We then press the OK button and then select the appropriate data in order to create the Power View Report.
If we had created a Power View Report, and later on we had deactivated the Power View add-in, when we open the Workbook that had the Power View Report, it will not be properly displayed as shown in the image below.
We then get the following message which mentions the following:
Power View Disabled: Some Sheets Will Not Display Correctly, Because They Were Made With The Power View Add-In.
All we have to do is to press the Enable button which is located at the right of the message and the Power View Report will be displayed properly again.
Once we have finished creating our Report with the use of Power View, and we are ready to print it, all we have to do is to select the File tab in order to move to backstage view. Then from the drop down menu that appears we select the Print command from the left of the menu as shown in the image below. Then we have a preview from our Report as we can see below and all we have to do is to adjust the settings that we want and press the Print button.
Below you can check out the video with the issues that might occur to us when we use the Power View command in Excel 13.
Posted on April 4, 2014, in Excel English 2013, Microsoft Office 2013 English and tagged Add Selected Data To An Existing Power View Sheet, Create a Power View Sheet, Excel 13, Microsoft Excel 13, Microsoft Office 13, MVP, Office Smart, Office System, Power View Disabled, Power View Report, Smart Office, The Power View Field Name Is Not Valid. Bookmark the permalink. Comments Off on Power View In Excel 13 Part 3.