Hi everyone

I have two excel files

1. ABC.xls
2. CDE.xls

I am just trying to link the values in ABC.xls to table in CDE.xls by
inputting this formulae in the cell.

='[ABCxls]Sheet1'!A1

This works perfectly fine except I have to do this for range A1:
AL1000. I just copy A1 because it has that formulae and paste special -
formula for range A1:AL1000. It copies the formula and puts it in
the right manner however I don't get any values from ABC.xls unless I
double click that individual cell.
It is like I click the cell, it has the formlua there but It won't
actually execute and return the value unless I double click that cell.

Please help,

Thank you for you help in advance.


regards,

James