ExcelHome技术论坛

 找回密码
 免费注册

QQ登录

只需一步,快速开始

快捷登录

搜索
EH技术汇-专业的职场技能充电站 妙哉!函数段子手趣味讲函数 Excel服务器-会Excel,做管理系统 效率神器,一键搞定繁琐工作
HR薪酬管理数字化实战 Excel 2021函数公式学习大典 Excel数据透视表实战秘技 打造核心竞争力的职场宝典
让更多数据处理,一键完成 数据工作者的案头书 免费直播课集锦 ExcelHome出品 - VBA代码宝免费下载
用ChatGPT与VBA一键搞定Excel WPS表格从入门到精通 Excel VBA经典代码实践指南
查看: 6621|回复: 5

[求助] 打开power view的时候出现这个提示怎么办呢?

[复制链接]

TA的精华主题

TA的得分主题

发表于 2018-11-10 16:06 | 显示全部楼层 |阅读模式
1541836996.jpg
打开power view的时候出现这个提示怎么办呢?请大家解答一下,谢谢。

TA的精华主题

TA的得分主题

发表于 2018-11-10 20:51 | 显示全部楼层
今天我也遇到同样的问题,寻求帮助!
360截图20181110203440634.jpg

TA的精华主题

TA的得分主题

发表于 2018-11-11 10:21 | 显示全部楼层
本帖最后由 123-456789 于 2018-11-11 16:21 编辑

可能是周末的原因,论坛里的高手都出去旅游了,一时半会没人解答上述问题。无奈只好自己上微软官网查找问题的原因。庆幸的是还真的找到。由于本人不懂英文,只能胡乱猜测一二。
Flash, Silverlight, and Shockwave controls blocked in Microsoft Office
Excel for Office 365 Word for Office 365 PowerPoint for Office 365
For security reasons new builds of Microsoft Office for Office 365 on Windows block activation of Flash, Silverlight, and Shockwave controls. Most users won't be impacted, but for some users this may cause one of the following issues:

When you click on an embedded Flash movie in PowerPoint Slide Show, nothing happens even though this worked before.

Power View in Excel does not work anymore (because it uses Silverlight). You may see an error message that says "Activate method of OLEObject class failed".

There are two ways you can unblock these controls. The first is by downloading a small package of registry keys. The second, by manually editing the registry yourself.

Download a package of registry keys
To unblock these controls, click here to download the free package of registry keys. There are easy instructions on the download page to tell you how to proceed.

I'd rather do it myself
Caution: Follow these steps carefully. Serious problems may occur if you modify the registry incorrectly. Before you start we recommend that you have a known good backup of your registry. See this article for more information: How to back up and restore the registry in Windows.

Exit all Microsoft Office applications

Start the Registry Editor by tapping Start (or pressing the Windows key on your keyboard) then typing regedit and pressing enter.

Locate the proper registry subkey. It will be one of the following:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Common\COM Compatibility\
(for 64-bit Office, or 32-bit Office on 32-bit Windows)

or

HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\16.0\Common\COM Compatibility\
(for 32-bit Office on 64-bit Windows)

Note: The COM Compatibility node may not be present by default. If you don't see it, add it by right-clicking the Common node and choosing Add Key.

Add a new subkey with the CLSID of the control you want to unblock as the value by right-clicking the COM Compatibility node and choosing Add Key.

Control

CLSID

Flash

{D27CDB6E-AE6D-11CF-96B8-444553540000}

{D27CDB70-AE6D-11CF-96B8-444553540000}

Silverlight

{DFEAF541-F3E1-4c24-ACAC-99C30715084A}

Shockwave

{233C1507-6A77-46A4-9443-F871F945D258}

Note: For Flash you'll need to add two subkeys, one for each of its CLSID's.

Within that new subkey we're going to add two new values by right-clicking the new subkey and choosing New > DWORD (32-bit) Value.

A REG_DWORD hexadecimal value called Compatibility Flags with a value of 0.

A REG_DWORD hexadecimal value called ActivationFilterOverride with a value of 1.

Exit Registry Editor and start your application. The control you need should be unblocked now.

Example
For example, to unblock Silverlight in order to get Power View working in Office 2016, 64-bit, on Windows you would locate this registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Common\COM Compatibility\

Note: Remember, if the COM Compatibility node doesn't exist yet you'll need to create it.

Then add a subkey with the value {DFEAF541-F3E1-4c24-ACAC-99C30715084A}.

In this case, the resulting path is HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Common\COM Compatibility\{DFEAF541-F3E1-4c24-ACAC-99C30715084A}.
To that subkey you'll add a REG_DWORD value called Compatibility Flags with a value of 0, and a REG_DWORD value called ActivationFilterOverride with a value of 1.
大致意思是:出于安全考虑,微软Office 365办公室阻止了Windows的Flash的激活,Silverlight冲击波的控制。受此影响的有Office 356、Office 2016、Office2019。相关用户可以按需自己激活,具体就是修改注册表。一是手动修改,二是下载相关插件自动修改。
由于对注册表的无知,我选择了下载插件(网上去下载Silverlight.exe的压缩包)。退出全部Office相关应用,安装Silverlight.exe插件,重新起动Excel,power view正常打开。
到此问题完美解决,希望论坛里其他有相同问题的兄弟姐妹也能顺利解决。

评分

1

查看全部评分

TA的精华主题

TA的得分主题

发表于 2018-11-11 10:47 | 显示全部楼层
本帖最后由 123-456789 于 2018-11-11 16:24 编辑

问题自己解决!!!!
美中不足的是power view中的语言变成英文的了,将就用吧。

TA的精华主题

TA的得分主题

发表于 2018-11-13 10:48 | 显示全部楼层
微软都已经弃坑的工具,苟且不了几天的,我的建议是直接弃坑

评分

1

查看全部评分

TA的精华主题

TA的得分主题

发表于 2018-11-16 13:36 | 显示全部楼层
Power View,确认用处不大,要么直接在BI中操作,那里的图表多的是,完全可跳过View。

评分

1

查看全部评分

您需要登录后才可以回帖 登录 | 免费注册

本版积分规则

手机版|关于我们|联系我们|ExcelHome

GMT+8, 2024-12-5 10:38 , Processed in 0.050667 second(s), 11 queries , Gzip On, MemCache On.

Powered by Discuz! X3.4

© 1999-2023 Wooffice Inc.

沪公网安备 31011702000001号 沪ICP备11019229号-2

本论坛言论纯属发表者个人意见,任何违反国家相关法律的言论,本站将协助国家相关部门追究发言者责任!     本站特聘法律顾问:李志群律师

快速回复 返回顶部 返回列表