Excel: Removing Chart Links to a Worksheet in a MacroLast reviewed: September 2, 1997Article ID: Q78463 |
The information in this article applies to:
SUMMARYA chart may be made independent of a worksheet by using a Microsoft Excel macro to convert any links to the worksheet to values.
MORE INFORMATIONTo convert a series formula to values manually, activate the formula bar by pressing F2 and then press F9 to convert the formula to values. To accomplish this from a macro, use the SEND.KEYS command. This must be done for each series formula in the chart. Because keystrokes sent with the SEND.KEYS command are typically not executed until a dialog box is displayed or a RETURN is executed, attempting to send keystrokes in a looping structure does not work properly. The following macro simulates a loop and works properly because the RETURN statement is executed after each SEND.KEYS statement. Note that the macro may not run properly if you attempt to step through it.
Example
For more information on this topic, query on:
on.time and send.keys and excelFor an article that describes this same subject using Visual Basic for Applications, please see the following article in the Microsoft Knowledge Base:
ARTICLE-ID: Q124232 TITLE : XL5: Visual Basic Macro to Break Chart Links REFERENCES"Microsoft Excel Function Reference," version 3.0, pages 2, 64, 159, 217
|
Additional query words: 3.00 3.0 4.0 4.00 5.0 5.00 break breaking
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |