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.

Issue 1:

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.

Create A Power View Sheet

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.

Add Selected Data

Issue 2:

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.

Power View Field Name Not Valid

We then press the OK button and then select the appropriate data in order to create the Power View Report.

Issue 3:

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.

Power View Disabled

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.

Print Power View Sheet

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.

Power View In Excel Part 3

About Smart Office - philippospan

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on April 4, 2014, in Excel English 2013, Microsoft Office 2013 English and tagged , , , , , , , , , , , . Bookmark the permalink. Comments Off on Power View In Excel 13 Part 3.

Comments are closed.