Setting Up SharePoint FIrst Time

Hi   We moved files from a local drive to to SharePoint (creating a site) in the process.    The problem we have incurred is on excel sheets that have VLOOKUPs that reference another workbook. If...