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
|