Lose reference to external data when moving files

[winspear]

Hi

Can anyone help with the following Excel 2003 problem please?

I have an external access database, currently held in the same folder as an excel file.

I have set the excel file up to call this information using data>import external data and it refreshes on opening.

I now need to move both of these files into new folders, however, when I do this, the excel sheet no longer updates when the database changes - is there an easy way to fix this?

Many thanks