Link to specific cell in specific Excel file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I want to make a link from a cell in a worksheet to a specific cell (let's
say C:312 in worksheet "Sheet3") in another specific Excel file (let's say
New_Excel_File.xls).

How can I do that?

Thanks, JeroenM.
 
Open both files and arrange the file windows so that both are visible
on screen at the same time. Then with your cursor in cell C312 of
Sheet3, type the equals sign then click on the other file window and
sheet tab and cell where you want the data to be brought from. Then
just press the <Enter> key and the formula (with the correct syntax)
will have been built up for you in the first file. If you close the
New_Excel_file window, then the formula will expand to include the
path.

Hope this helps.

Pete
 
the simplest way is to be in the cell you want the link to show up enter =
and go to the book and sheet you want and select the cell.
you will end up with something like
='[New_Excel_File]Sheet3'!C312
the advange to using the moue to just typing it in is that if you make as
many typos as I do, you won't have to retype it as often.

another method is to goto the cell you wnt to link to in the new file, copy
it, go to where you want the data to show and paste special link.
 
Hi,

Do the followinf:

1. Select the cell in the first sheet.
2. On the Edit menu, click copy
3. To move to your next excel file press ALT+Tab.
Note: AlT+Tab only works if you have two different Work book. However, to
select different sheet with a Workbook, you have click the Windows menu.
4. Click to select cell locaton.
5. On the Edit menu, click Paste Special.
6. In the Paste Special dialog box, click Paste link.
In the formual bar, you will notice the Source file path and cell refernce
with "$" symbol. This represents the absolute reference link to your source
location.
6. Click OK.

Challa Prabhu
 
Back
Top