Saves copies of values contained in an external document linked to an Excel sheet. If a sheet with links to large ranges ...

Saves copies of values contained in an external document linked to an Excel sheet. If a sheet with links to large ranges on an external document requires an unusually large amount of disk space or takes a long time to open, you can clear the Save External Link Values check box to reduce the disk space and time needed to open the sheet.

Affects: only the active workbook.