Copy Paste
 

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

Copy Paste
 

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

Copy Paste
 

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