saving info in drop down boxes
 

I am using office 2003 and after I save a spreadsheet and I close it when I
go back into it the drop down boxes are there but the list in the box is
gone. Also I am on a network and the info in the dropdown boxes does not
appear if I access the sheet from a different computer. HELP!!!
(FYI: I am pulling the list in the drop downs off of a seperate spreadsheet)