Share Button

Microsoft Windows OS always keeps itself updated with changing times and its requirements. That is why it always keeps Microsoft office updated also. So, I hope you have heard that on April 8, 2014, Microsoft ended support for office 2003. This change has affected your software updates and security options..

Symptoms

When Microsoft office users open a workbook in Microsoft Excel, then they may receive the following error message:
This workbook contains links to other data sources.

  1. If they update the links, Excel attempts to retrieve the latest data.
  2. If they do not update, Excel uses the previous information.

If they click on the Update then they receive the following error messages:
This workbook contains one or more links that cannot be updated.

  1. Click on the Edit Links to change the source of links, or attempt to update values again.
  2. Click on the Continue to open the workbook as is.

Causes

There are mainly two causes of Error opening workbook containing links to HTML workbook in Excel. These two causes are as following:

  1. Excel cannot links from a workbook that is saved in the HTML file format if that workbook is closed
  2. Excel updates the links correctly if the link source file is already opened.

Solution

As we know that Excel can be linked to html but the format of both (html and Excel) are different so before updating link in workbook open the html file which is linked in workbook in Excel because Excel cannot update links from a workbook which is saved in html format.

Fix netsvc.exe error using Advanced System Repair Tool

  • The most common reason behind this error is installing incompatible or outdated driver, missing system files, corrupted registry file or damaged pc by viruses. Advanced System Repair Tool is the only solution for all the system errors. By installing this tool you will be able to remove above windows error.
    3 Steps to Fix this Error

    Step 1. Download Advance System Repair Tool [File Size: 15.7 MB]
    Step 2. SCAN your Windows PC
    Step 3. Click Fix button to Repair Error

Share Button
Error Opening Workbook Containing Links to HTML Workbook in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *