Microsoft KB Archive/20807

External Copy With Linked Set to Yes PSS ID Number: Q20807 Article last modified on 10-17-1990 PSS database name: D_MPlan

2.x 3.00 3.01 3.02 3.04 4.00 4.01 4.20

MS-DOS

Summary:

When data in a worksheet is derived from an external copy with link set to Yes, the cells containing the data are locked and cannot be edited.

To update the values, new values must be entered into the supporting (external) worksheet. You then can reload the dependent (target) worksheet. A link is not updated unless the source worksheet has changed.

A named area can be copied twice: once by using the name, and a second time by using the row/column reference.

To copy an external area more than twice, the same area in the external sheet must have more than one name; then, each name can be used in the external copy command. Once data has been transferred, any formulas in the dependent worksheet can reference that data. Therefore, there is essentially no reason to externally copy data into a single dependent worksheet more that once.

Copyright Microsoft Corporation 1990.