Excel 2007 : link to another excel file - not working

**airy07** · 08-16-2011, 03:04 AM

Hi. I'm new to excel.

i tried to link a cell to other excel file but it won't work.

i tried linking the cells of the same excel file and the linking works just fine.

i was wondering what setting should i make so linking of different excel file
will work.

thank you for your time.

**romperstomper** · 08-16-2011, 04:13 AM

"Won't work" in what way?

**airy07** · 08-17-2011, 12:55 AM

like, for example.

my opened file is "sample1.xls" and "otherfile.xls".
i want to show in sheet1, cell a2,b3 of sample1.xls the figure in cell a7,b2 of otherfile.xls.
i placed "=" sign in sheet1, cell a2,b3 of sample1.xls
and then click cell a7,b2 of otherfile.xls
then pressed "enter" but nothing happened.

the broken line indicator that always appears whenever you want to link
a cell to another cell won't appear.

**romperstomper** · 08-17-2011, 02:31 AM

It sounds as though you have two separate instances of Excel running. Try opening both files from within Excel rather than from Explorer.

**airy07** · 08-17-2011, 03:53 AM

oh wow! it worked!

thanks!

**romperstomper** · 08-17-2011, 05:06 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save