Excel file linked to access database

Hi there

I have created a 'price list' database in ACCESS. Then in EXCEL I created a pivot table which retrieves data from one of the database queries (the query was saved as a .dqy file).

I emailed the file containing the pivot table to a colleague who is on the same server. He saved the excel file on he desktop & renamed it.

When I update the databse file on a shared public drive on the server, he is able to 'refresh' his desktop file successfully !!

How does this work??? How does it keep the link???

Many thanks - a response is greatly appreciated
Si