That way, if the data changes online, you can update it by refreshing it in Excel. Once you convert text to a linked data type, an external data connection is established in the workbook.
This is because they refer to an online data source.
The Stocks and Geography data types are considered linked data types.