Enabling security access for Microsoft Excel, Word, and PowerPoint exports

Security settings in Microsoft Excel, Word, or PowerPoint may 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 machine, 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.

Note: 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

Note: Setting the security options in one program does not set them in the other. You may 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.

Ensure that IBM® SPSS® Data Collection Survey Reporter and all Microsoft Office applications are closed.

Open Excel, Word, or PowerPoint.

Click the Microsoft Office button.

Click the Excel Options, Word Options, or PowerPoint Options button.

Click

In Excel, additionally click Macro Settings.

Select the Trust access to the VBA project object model check box.

Click OK to apply the setting.

Close Excel, Word, or PowerPoint.

For more information, see Enable or disable macros in Office documents at http://office.microsoft.com/en-us/help/HA100310711033.aspx.