The Excel Power View tab does not display the issue

https://zhuanlan.zhihu.com/p/43543442

Powerview is one of the power series plug-ins in Excel that can make interactive dashboards based on Excel.

Beginners often encounter problems in using Power view, and today we summarize the top 3 most common questions that you will encounter:

Top1 How to load the Power View tab

For pro Excel users, using Power view requires that you check activation in the Add-in first.

Select file → options → add-ons → select COM add-ons → go to (not OK)

In the "COM Add-ins" window that pops up, tick "Microsoft Power view for Excel" and click OK to activate Power view.

However, after activation many learners find that there is no power View tab in the Excel menu,

This is because Power view is hidden by default and we need to set it up manually:

Click "File" → "Options" and click on the "Excel Options" screen that pops up:

• Customizing the Ribbon
• Select Main tab from select commands from
• Select Power View
• Click "Add"
• On the right, you see Power view (Custom), not power view. (You can also adjust the upper and lower order)
• Click "OK"

After that, Power view is loaded into the main tab.

In addition, some users will find that the Power View tab disappears when they are in use, which can be activated again by repeating the above actions.

TOP2 Power view cannot be used

Users who use Power view for the first time often experience the following scenario:

This situation is generally not installed Mircrosoft sliverlight, we need to install Microsoftsliverlight, click on the "Install Silverlight".

Note: You can interpret siverlight as a Microsoft Flash plugin to support interactive rendering of power view.

You can also login to the URL https://www.microsoft.com/silverlight/, click Downloadnow to download the installation.

You can turn on power View by reopening Excel when the installation is complete.

If not, refer to the help here to download the Enablecontrols.zip file from the Script Center

Double-click the extracted Enablesliverlight.reg file.

Select "Yes" in the pop-up warning dialog and restart the Excel software.

TOP3 map background does not support your region

The first time you use Power view you will often encounter this problem, and the map background is grayed out, prompting "the Mapbackground from Bing are not available for this locale."

If you encounter this problem, you can solve the following steps:

1. Open "Control Panel" and select "Change date, time or number format" in "clock, language and region"

2, in the area pop-up window, "format" select "English (United States)." Then restart power view to resolve.

Note: This issue is not related to settings such as location/language preferences, just adjust "format" as described above

article reference: 3 most common questions for beginners to use power view

The Excel Power View tab does not display the issue