Hello - I have a large payroll workbook with links and lookups to several other workbooks. However, if I move one of those files my master payroll file does not update the formula to lookup to the file in the new location. Or I will get error messages if those other workbooks that I am looking up to are not open.

Does anyone know why this is? I have just started having this problem after getting a new computer and don't know if it has to do with the settings....

Thanks so much!