G
[G]rumpy [O]ld [D]uffer
I have an EXCEL file (named 'Master') with 2 worksheets.
On each of these worksheets I have formulae which links with data on 2
different EXCEL files (named 'Data 1' & 'Data 2'). These 2 files only
hold tables containing data inputs (i.e. no formulae).
When I open the 'Master' file it asks if I want to refresh the Links,
which I do. When this is completed one worksheet in the 'Master' file
shows what I expect it too, having been linked to 'Data 1' file.
However, the other worksheet shows #VALUE! in all the cells that
relate to a link in the 'Data 2' file. If I then open 'Data 2' file
and then immediately close it, then look at the problematic worksheet
in the 'Master' file, everything has been correctly populated with the
figures from the 'Data 2' file.
I'm using EXCEL 2000.
What is the problem on this? I wrote the formulae with all files Open,
then Saved & Closed all files, then opened the 'Master' file only to
discover this problem.
On each of these worksheets I have formulae which links with data on 2
different EXCEL files (named 'Data 1' & 'Data 2'). These 2 files only
hold tables containing data inputs (i.e. no formulae).
When I open the 'Master' file it asks if I want to refresh the Links,
which I do. When this is completed one worksheet in the 'Master' file
shows what I expect it too, having been linked to 'Data 1' file.
However, the other worksheet shows #VALUE! in all the cells that
relate to a link in the 'Data 2' file. If I then open 'Data 2' file
and then immediately close it, then look at the problematic worksheet
in the 'Master' file, everything has been correctly populated with the
figures from the 'Data 2' file.
I'm using EXCEL 2000.
What is the problem on this? I wrote the formulae with all files Open,
then Saved & Closed all files, then opened the 'Master' file only to
discover this problem.