If workbook A is linked to workbook B,workbook A must be closed when shared copies of workbook B are created in order to prevent the references in workbook A from being automatically changed to reference the new files.

Question

Quizplus · Accepted Answer

When shared copies of workbook B are created, Excel automatically changes the references to point to the new files. If workbook A is still open, these references may also be changed, affecting the original data. Therefore, to prevent this from happening, workbook A should be closed when shared copies of workbook B are created.

If Workbook a Is Linked to Workbook B,workbook a Must