Microsoft KB Archive/74263

{| = Excel: Linked Attached Text Causes Macro Error =
 * width="100%"|

Last reviewed: October 7, 1997

Article ID: Q74263 3.00 MACINTOSH kbother

SUMMARY
If you use a macro to attach text in a chart that uses a formula to link to a cell on a Worksheet, Excel may return the error &quot;Formula is not Valid.&quot;

Please contact Microsoft Product Support Services at 425-635-7080 for more information.

For example, the following macro may cause the &quot;Formula is not Valid&quot; error message to appear:

=ATTACH.TEXT(1) =FORMULA(&quot;=Worksheet1!R1C3&quot;) =RETURN To workaround this, deselect the chart title and then reselect it before changing it's contents. For example, the above macro becomes: =ATTACH.TEXT(1) =SELECT(&quot;Chart&quot;) =SELECT(&quot;Title&quot;) =FORMULA(&quot;=Worksheet1!R1C3&quot;) =RETURN
 * }