The basic difference between a published data source and an embedded data source is:
The public data source contains connection information that is independent of any workbook. On the other hand, embedded data source connection information and is associated with a workbook.
