prompted for workbook location

[stoopid_newbie]

Having previously used excel 2000 I used a spreadsheet which contained Hlookup and Vlookup statements within a macro which point to a separate workbook.

Now using Excel XP I find that when this Macro is activated I am prompted for the location of this workbook.

This never happened before and the location of the workbook has not changed.

Is there a way to do this automatically???

Cheers.