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 Unit.xls]#REF'!$A:$L,3,FALSE)),,(VLOOKUP($C13,'[HO-CORP01 - Overheads Final By Business Unit.xls]#REF'!$A:$L,3,FALSE)))
I have tried opening up all all files and it still doesn't work.
I am also having the same problem with another file which has Graphs linked to other 2003 spreadsheets and the link for the Graphs doesn't update either.
Is there a fix? Please Help!!!
=IF(ISERROR(VLOOKUP($C13,'[HO-CORP01 - Overheads Final By Business Unit.xls]#REF'!$A:$L,3,FALSE)),,(VLOOKUP($C13,'[HO-CORP01 - Overheads Final By Business Unit.xls]#REF'!$A:$L,3,FALSE)))
I have tried opening up all all files and it still doesn't work.
I am also having the same problem with another file which has Graphs linked to other 2003 spreadsheets and the link for the Graphs doesn't update either.
Is there a fix? Please Help!!!