Microsoft KB Archive/33528

Increasing Size of Linked Area Prevents Updating PSS ID Number: Q33528 Article last modified on 01-12-1989 PSS database name: D_MPlan

1.x 2.x 3.x 4.00

MS-DOS

Summary:

If columns or rows are inserted into the named area of a supporting spreadsheet that is externally linked into a dependent spreadsheet, the linked area will not update correctly in the dependent sheet.

When you load the dependent sheet, you will be prompted with the message “Confirm Change:”. Regardless of how you respond to this prompt, the linked area will not update to reflect the extra rows or columns that you have inserted in the named area on the supporting sheet.

More Information:

This problem occurs because Multiplan uses absolute cell references to define a named area. These absolute references are retained in the dependent sheet and will not read the changed named area of the supporting sheet. The only way to correctly update the link is to delete the link in the dependent sheet and then recreate it.

To delete the link, do the following:


 * 1) Load the dependent sheet and issue the eXternal Copy command.
 * 2) Fill in the “sheet:” and “name:” fields with the name of the link you wish to break.
 * 3) Tab to the “to:” field.
 * 4) Press the DEL key to blank the field, and then press ENTER.

This process will delete the link. At this point, if you recreate the link, the changed named area will be linked correctly.

Copyright Microsoft Corporation 1989.