Copy Paste

[James8309]

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]

Make sure that you have calculation set to automatic.

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

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

 

[Shane Devenshire]

Hi,

In 2007 the command is
Formulas, Calculation Options, Automatic

If this helps, please click the Yes button

Cheers,
Shane Devenshire

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