Microsoft KB Archive/64204

Change.Link? Error in Excel Documentation PSS ID Number: Q64204 Article last modified on 04-30-1993 PSS database name: W_eXceL

2.x 3.00 4.00 | 2.20 2.21 3.00 | 2.x 3.00 4.00

WINDOWS | OS/2 | MACINTOSH

Summary:

The following documentation error occurs in all versions of the Product for the Windows, OS/2, and Machintosh platforms.

According to these Function Reference manuals

Page 257, “Microsoft Excel Functions and Macro” guide for Windows, Page 256, “Microsoft Excel Functions and Macro” guide for OS/2, Page 28, “Microsoft Excel Function Reference” version 3.0, Page 48, &quot;Microsoft Excel Function Reference, version 4.0,

you can use the Change.Link? function with no parameters (the parameters, “old_link,new_link” for version 2.x or “old_text,new_text” for versions 3.0 and 4.0, are in italics). This is incorrect; the old_link (old_text) parameter is not optional, but the new_link (new_text) parameter is. In many cases, you will not know what the links will be, or they will change depending on what worksheet is being used in conjunction with the macro.

The following is a way to avoid specifying a specific old_link:

=CHANGE.LINK?(INDEX(LINKS,1,1))

Note: If your active document does not contain any links, you will receive an error when your macro is run.

Additional reference words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 3.00 4.0 4.00 mpf

Copyright Microsoft Corporation 1993.