Desktop User Guides > Professional > Table scripting > Exporting tables > Enabling security access for Microsoft Excel, Word, and PowerPoint exports
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 will inform 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, please 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 later
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 in the Trust Center.
1 Ensure that UNICOM Intelligence Professional and all Microsoft Office applications are closed.
2 Open Excel, Word, or PowerPoint.
3 Click the Microsoft Office button.
4 Click the Excel Options, Word Options, or PowerPoint Options button.
5 Click Trust Center > Trust Center Settings.
6 In Excel, additionally click Macro Settings.
7 Select Trust access to the VBA project object model.
8 Click OK, and then close Excel, Word, or PowerPoint.
For more information, see “Enable or disable macros in Office documents” at:
See also
Exporting tables