Microsoft Excel Workbook Links

Opening certain Excel or Comma Separated Value (CSV) files in Excel may (correctly or incorrectly) produce the following error message:

This workbook contains one or more links that cannot be updated.

Depending on how the file was opened (either through the GUI or programmatically), the following message box may appear:

Clicking the "Edit Links..." button opens the following window:

Selecting just about any option continues loading the file; however, if the files was accessed programmatically, user intervention is required through the GUI (even when the application has set Application.DisplayAlerts = false).

To disable the automatic update of Workbook links in Microsoft Excel 2007, which suppresses the prompt:

• Open Excel
• Click on the Microsoft Office button (in the upper left corner of the application)
• Click "Excel Options" near the bottom of the menu
• Select "Trust Center" tab
• Click the "Trust Center Settings..." button
• Select "External Content" tab
• Select "Disable automatic update of Workbook Links"
• Click "OK" button to close the "Trust Center" window
• Click "OK" button to close the "Excel Options" window

Addition information pertaining the issue is available through Microsoft's support website:

• http://support.microsoft.com/kb/813977

Microsoft Office Outlook Connector

If you use Microsoft Outlook to check your e-mail and have a Hotmail or Windows Live e-mail account, I strongly recommend installing the Microsoft Office Outlook Connector. The Microsoft Office Outlook Connector uses MAPI to access HTTP mail accounts, which provides additional functionality and a much smoother experience.

Get Microsoft Office 2007 Ultimate Edition for only $59.95

Microsoft has a great promotion going for college students; get Microsoft Office Ultimate 2007 for just $59.95, but you will have to hurry the offer ends on April 1, 2008.

"Office Ultimate 2007's brand new features and fresh look will help you organize and get all your work done in the blink of an eye."

Avoid sending e-mail messages by mistake

Have you ever accidentally sent an e-mail before you were done? Or sent something that you immediately wished you hadn't?

Here's an article that explains how to configure Outlook to delay the delivery of messages, giving you an opportunity to stop them from being sent:

Avoid sending e-mail messages by mistake