S
Stef
Hi,
We just migrate to Excel 2002 and we are having a hard
time getting back the values in the cells of linked
workbook. When we open those workbook (created in 97 read
in 2002) it ask if we want to update the links but no
matter what we answer it update it... and worst, if the
source workbook is no longer where it was when we link it
we lose the values and have #REF everywhere. The
breaklink method would have work if we could use it in 97
but this function was not in the 97 version...
We do not care if we lost the links but we need the
values... any ideas???
We just migrate to Excel 2002 and we are having a hard
time getting back the values in the cells of linked
workbook. When we open those workbook (created in 97 read
in 2002) it ask if we want to update the links but no
matter what we answer it update it... and worst, if the
source workbook is no longer where it was when we link it
we lose the values and have #REF everywhere. The
breaklink method would have work if we could use it in 97
but this function was not in the 97 version...
We do not care if we lost the links but we need the
values... any ideas???