激活方法如下:
1、点击“Office按钮”,从其扩展面板中点击“Excel选项”按钮。
/iknow-pic.cdn.bcebos.com/810a19d8bc3eb13587c56edda81ea8d3fd1f4452"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/810a19d8bc3eb13587c56edda81ea8d3fd1f4452?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/810a19d8bc3eb13587c56edda81ea8d3fd1f4452"/>
2、在打开的窗口中,勾选“在功能区显示‘开发工具’选项卡”项,并点击“确定”按钮。
/iknow-pic.cdn.bcebos.com/377adab44aed2e739dca5f4a8901a18b87d6fab1"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/377adab44aed2e739dca5f4a8901a18b87d6fab1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/377adab44aed2e739dca5f4a8901a18b87d6fab1"/>
3、接着切换至“开发工具”选项卡,点击“宏安全性”按钮。
/iknow-pic.cdn.bcebos.com/a5c27d1ed21b0ef4c1324138d3c451da80cb3efa"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/a5c27d1ed21b0ef4c1324138d3c451da80cb3efa?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/a5c27d1ed21b0ef4c1324138d3c451da80cb3efa"/>
4、从打开的窗口中,勾选并且单击“启用所有宏”项,这样excel大多数功能被禁用的问题就解决了。
/iknow-pic.cdn.bcebos.com/7aec54e736d12f2e3e26760641c2d562853568b1"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/7aec54e736d12f2e3e26760641c2d562853568b1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/7aec54e736d12f2e3e26760641c2d562853568b1"/>