Solution Open the Microsoft Excel workbook. Click the 'Microsoft Office' button. Click the 'Excel Options' button. In the left pane, click 'Trust Center'. In the 'Microsoft Office Excel Trust Center' section, click the 'Trust Center Settings' button. In the left pane, click 'External Content'. In the 'Security settings for Data Connections' section, select the 'Disable all Data Connections' check box. Click 'OK'. Click 'OK'.
Details
Microsoft Excel 2007 is configured to protect worksheet elements from external threat such as viruses. If the worksheet is not protected properly, the malicious content can corrupt or damage the worksheet data. To protect the worksheet against external threats, you must disable all the external data connections included in a workbook.To disable all the external data connections included in a workbook:
1) Open the Microsoft Excel workbook.
2) Click the 'Microsoft Office' button.
3) Click the 'Excel Options' button. (The 'Excel Options' dialog box appears.)
Screen: 'Excel Options' dialog box
4) In the left pane, click 'Trust Center'. (The 'Trust Center' screen appears.)
Screen: 'Trust Center' screen
5) In the 'Microsoft Office Excel Trust Center' section, click the 'Trust Center Settings' button. (The 'Trust Center' dialog box appears.)
Screen: 'Trust Center' dialog box
6) In the left pane, click 'External Content'. (The 'External Content' screen appears.)
Screen: 'External Content' screen
7) In the 'Security settings for Data Connections' section, select the 'Disable all Data Connections' check box.
8) Click 'OK'.
9) Click 'OK'.
Knowledge-Paks Online and Knowledge-Paks On Site Copyright (c) 2008 by RightAnswers, Inc. Subject to the terms set forth in the end-user license agreement. All rights reserved.