input range across workbooks

[hawley]

I am having another issue with dropdown boxes on a worksheet. Last night DRJ helped me define the input range. Now my problem is that it works on my computer but not my users. I am populating the dropdown from another workbook. When I look at my input range I see:
ad_forms.xls!Promotions
When I look at there input range I see:
\\KOHLNT62\Prod\Prod\APPS\Forms\ad_forms.xls!Promotions

The funny thing is we both have the two workbooks open. I do see what they get when I don't have the ad_forms.xls open. Any suggestions or ideas. I am using Excel 97.

Thanks in advance!!!!!

 

[hawley]

Does anybody have any ideas on this???

 

[hawley]

Found a solution.

I need to point to the drive letter instead of the server name. Also I needed to get rid of phantom links. After doing this and remapping it worked.