Linking to external data sources can keep your workbook's file size down by not storing the data directly in the workbook. However, ensure reliable connectivity to these sources to avoid data access issues. Use Excel's data connection features to refresh data from these sources dynamically, keeping your workbook up to date without the bulk of the data being stored within it.