putting a dynamic report on the intranet
 

The Get External Data works fine from my computer, but is it possible for
the embedded query to remain connected to Access, if the .xls is stored in a
shared drive folder, and linked to by a hyperlink/URL from the corporate
intranet page? As far as I can tell that removes the auto-refresh/link to
the Access data, or am I missing something somewhere? Everyone is using
Excel 2003, Access 2003 and do not have SharePoint where I work. They don't
want to use DataAccess Pages.

Can this be done?