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 both workbooks are moved to sharepoint should it update the external references or do you have to do this manually for each spreadsheet?

Thanks

Stuart