XL: Using the Update Add-In Links File UPDTLINK.XLA

• Microsoft Excel for Windows, version 5.0
• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel 97 for Windows

SUMMARY

The Updtlink.xla file is the Update Add-in Links add-in that is included with Microsoft Excel. This file updates links to Microsoft Excel version 4.0 add-ins to directly access the built-in functionality in Microsoft Excel versions 5.0, 7.0 and 97.

MORE INFORMATION

Worksheet and macro sheet functions contained in the following Microsoft Excel 4.0 add-ins are either contained in Analysis.xll (Microsoft Excel version 5.0 Analysis ToolPak add-in), Analys32.xll (Microsoft Excel versions 7.0 and 97 Analysis ToolPak add-in), or the functions are built-in to Microsoft Excel:

Analysis.xla - Analysis ToolPak macro functions are contained in

               Analysis.xll

               Analysis.xll

               RADIANS() functions are built-in functions in Microsoft
               Excel versions 5.0, 7.0 and 97.

               in Microsoft Excel versions 5.0, 7.0 and 97.

You can use the Update Add-in Links add-in to change these references for you. This add-in changes a link to a Microsoft Excel version 4.0 add-in to the Microsoft Excel built-in function or to the function contained in Analysis.xll.

When you open or load Updtlink.xla as an add-in, in Microsoft Excel versions 5.0 and 7.0, the "MS Excel 4.0 Add-in Links..." command appears on your Tools menu. In Microsoft Excel 97, the "Update Addin Links..." command appears. When you choose this command, a dialog box appears that allows you to update the links in the current document or all open documents.

NOTE: the BASE and FASTMATCH functions no longer exist in Microsoft Excel version 5.0, 7.0 and 97. Using these functions will return a #NAME! Error even after running the Updtlink.xla.

To use Updtlink.xla to change references to add-in functions, do the following:

1. Open the documents that contain the references to functions in the Microsoft Excel 4.0 add-ins listed above.

2. Open the file Updtlink.xla. This file is located in the LIBRARY subdirectory of the directory to which you installed Microsoft Excel version 5.0.

3. Open the file Analysis.xll (open Analys32.xll if you are using Microsoft Excel versions 7.0 or 97). This file is located in the ANALYSIS subdirectory of the LIBRARY subdirectory of the directory to which you installed Microsoft Excel version. (This step is not necessary if your document references Scenario.xla or the DEGREES() or RADIANS() functions.)

4. On the Tools menu, click MS Excel 4.0 Add-In Links (in versions 7.0 and 97 click Update Addin Links).

5. To update the references in the active workbook only, select Active Document. To update the references in all open workbooks, select All Open Documents. Click OK.

1. In Microsoft Excel 5.0 or 7.0, click Contents on the Help menu.

2. From the Microsoft Excel Help Contents screen, select Reference Information.

3. From the Reference Information screen, select Microsoft Excel Macro Functions Contents.

4. Click the Search button and type "links, Microsoft Excel 4.0, changing" (without the quotation marks) and choose Show Topics.

5. From the list of topics, select Changing links to Microsoft Excel version 4.0 add-ins and choose Go To.

REFERENCES

For more information about Installing Or Removing An Add-in, click the Search button in Help and type:

    add-ins