Cannot Change LINK Source File to Different Excel Worksheet

ID: Q113482

The information in this article applies to:

Microsoft Word for Windows, versions 6.0, 6.0a
Microsoft Windows, version 3.1

SYMPTOMS

In Word 6.0 for Windows, if you open a Word 2.x for Windows file that contains a link to a Microsoft Excel worksheet, you cannot change to a different source file. In Word, you can choose Links from the Edit menu, choose the Change Source button, select a new worksheet as a source file, and then choose OK; Word lists the new worksheet name in the Edit Links dialog box, and you can choose OK. However, the original Microsoft Excel worksheet continues to appear in the document and, if you re-open the Edit Links dialog box, Word again lists the original Microsoft Excel worksheet as the source file (as if you never choose the Change Source button and changed the source file).

This only happens with documents you created in Word 2.x. It does not happen with a document you originally created in Word 6.0.

CAUSE

Your Windows REG.DAT file does not contain a valid path to Microsoft Excel.

WORKAROUND

Method 1: Use the instructions below to update your REG.DAT file so it points to the correct location of Microsoft Excel. The advantage of this method is that it corrects the problem for all Word 2.x files that contain a link to a Microsoft Excel worksheet.

Open Windows File Manager.

Select one of the following two files:


             OLE2.REG (located in your <WINDOWS>\SYSTEM subdirectory)
             WINWORD6.REG (located in your Word 6.0 program directory)

From the File menu, choose Associate. REG should appear in the Files With Extension box (if it doesn't appear there, type it in).

From the Associate With list, select Registration Entries (regedit.exe) and then choose OK.

Double-click OLE2.REG. Choose OK when the following message appears in a Registration Info Editor dialog box:

Information in <PATH>\OLE2.REG has been successfully registered in the registration database.

Double-click WINWORD6.REG. Choose OK when the Registration Info Editor message appears.

Method 2: In Word, Use the Links command on the Edit menu to break the link and then to re-establish it.

Note: The drawback to this method is that it does not permanently resolve the problem. If you want to avoid the problem in the future, use Method 1.

Additional query words: 6.00a links convert officeinterop word6 excel registration database ole apps winword

Keywords : kbfield
Version : WINDOWS:6.0,6.0a; :3.1
Platform : WINDOWS
Issue type :