We have recently upgraded to office 2007 and when I open my monthly file which was created in 2003 and is linked to several other 2003 spreadsheets, none of links will work, "#REF" now appears in all the formula's:
=IF(ISERROR(VLOOKUP($C13,'[HO-CORP01 - Overheads Final By Business...