Enabling security access for Microsoft Excel, Word, and PowerPoint exports
Security settings in Microsoft Excel, Word, or PowerPoint might prevent you from exporting to these applications. If this occurs, you can enable the export to run by changing a security setting in Microsoft Excel, Word, or PowerPoint. If you need to change the setting on your computer, a message informs you of this. Follow the instructions below to change the settings. If you are in doubt about whether changing security settings is permitted by your organization, contact your system administrator.
Ensure that you have the latest Microsoft Office service pack installed. To check this, choose the Check for Updates option on the Microsoft Excel Help menu to display the Microsoft Office Downloads page, where you can download the latest service pack.
Microsoft Office 2007 or above
Setting the security options in one program does not set them in the other. You might need to follow these steps for Excel, Word, and PowerPoint depending on your existing security settings.
In Microsoft Office 2007, macro security settings are located in the Trust Center.
1 Ensure that UNICOM Intelligence Reporter - Survey Tabulation and all Microsoft Office applications are closed.
2 Open Excel, Word, or PowerPoint.
3 Click the Microsoft Office button, and then click the Excel Options, Word Options, or PowerPoint Options button.
4 Click Trust Center > Trust Center Settings
5 In Excel, also click Macro Settings.
6 Select Trust access to the VBA project object model, and then click OK.
7 Close Excel, Word, or PowerPoint.
For more information, see “Enable or disable macros in Office documents”:
https://support.office.com/en-US/Article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12?ui=en-US&rs=en-
US&ad=USSee also