|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file
Please can someone help me out here, I have an Excel file stored in my Disk (G:\Dont click 01\Excel doc special\Second Stock Account Ink sells record.xlsx) of my hard drive with worksheet reference (=All_stock_info!$E$13) or/with a name defined as
(Second_stock_money_collected) now I want to link the above Excel file worksheet reference to the below Excel file worksheet reference. Disk (G:\Dont click 01\Excel doc special\Ink sells record.xlsx) of my hard drive with worksheet reference (=All_stock_info!$E$13) or/with a name defined as (Second_stock_collection_ref) please can someone help me out, thanks in advance. |
#2
|
|||
|
|||
Hello,
In the Data tab, click in edit links. You can change the linked workbook for the other you want or need. |
#3
|
|||
|
|||
Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file
Sorry I can't find the edit link when I clicked on Data tab, I have the JPEG file of that Excel file which I used attached here please see.
|
#4
|
||||
|
||||
Samsnov, I think the easiest way to do this the first time goes like this. I'm going to refer to the Target workbook as "To", and the one you want to do the pointing as "Fm".
1) Open both workbooks. 2) In Fm, start a formula in one of the cells by typing "=". 3) Don't hit <Enter>; instead, leave that formula hanging and move to the target workbook, ie To. 4) Note that in the formula bar, the formula you started is still waiting to be completed. 5) Click a cell in the To workbook. Notice that in the formula bar, the formula in Fm now points to the cell in To. 6) Now you may hit <Enter>. At this point you can examine the formula you just created to see the syntax used for pointing to a workbook that's open. But wait, there's more! 7) Close the To workbook. 8) Now look at the formula in the Fm workbook. You'll note that the syntax has changed; it now includes not just the workbook name, but the path too. There you go: That's the syntax to use. Personally, I find it easier to create an external reference this way all the time; typing out the path and file name, and making sure I get all the punctuation in the right place, requires enough effort and proof-reading that letting Excel do it works faster for me. |
#5
|
|||
|
|||
Thank you very much BobBridges, I followed your instruction as directed and everything worked fine as wanted now the excel file cells are linked with the syntax generated by Excel ( ='G:\Dont click 01\Excel doc special\[Second Stock Account Ink sells record.xlsx]All_stock_info'!$E$13) once again thank you all for helping out.
|
#6
|
|||
|
|||
I also wanted to mark this thread as solved but I didn't see the option to do that here.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2013 Record Macro greyed out | av8r | Excel | 7 | 02-17-2016 08:04 PM |
Activate Worksheet with button in Excel 2013 | JTS | Excel | 1 | 08-25-2013 12:02 AM |
Word 2013 file opens as WD00000x and in 97 - 2003 format | duncanwil | Word | 0 | 07-23-2013 10:51 PM |
Secondary Horizontal Axis excel 2013 | darksupernova | Excel | 0 | 02-27-2013 08:46 AM |
Is it possible to link an Excel File to a Word table? | KIM SOLIS | Excel | 9 | 09-08-2011 07:05 AM |