How is excel storing connection information?

If it is using an external DSN, how is it I can send the xls to someone who
doesn't have the DSN and it works.

If it is not using a DSN, why is it that the wizard prompts you to choose or
create one?