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

Make sure that you have calculation set to automatic.

In xl2003 menus, it's under Tools|Options|calculation tab.

James8309 wrote:

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

--

Dave Peterson

Hi,

In 2007 the command is
Formulas, Calculation Options, Automatic

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"James8309" wrote:

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