How do I link them so that so that when I change some data in one, it changes in the other? I.E. I change the numbers in some cells on file1.xls and those cells are automatically updated in file2.xls?
2007-09-20 03:23:53 · 2 answers · asked by Jeff C 1 in Computers & Internet ➔ Software
Have them both open. In #1, create your formula and when it comes to the cell in #2, switch to #2 and click the cell. Look at how your formula changes to reflect that the data comes from another spreadsheet.
2007-09-20 03:28:03 · answer #1 · answered by Anonymous · 0⤊ 0⤋
You don't mention version. Here is probably more information than you need.
Microsoft Help for Excel
All Office versions for “link” Files
http://office.microsoft.com/en-us/help/results.aspx?qu=Excel+link+files
Excel 2000
http://office.microsoft.com/en-us/excel/HA010548121033.aspx?pid=CH010719671033
Excel 2003
http://office.microsoft.com/en-us/excel/HP051995141033.aspx?pid=CH010004921033
2007-09-20 10:42:08 · answer #2 · answered by TheHumbleOne 7 · 0⤊ 0⤋