Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-27-2013, 09:43 AM
samsnov samsnov is offline Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file Windows 7 64bit Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file Office 2010 64bit
Novice
Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file
 
Join Date: Sep 2013
Posts: 4
samsnov is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 09-27-2013, 09:47 AM
jsuarezg jsuarezg is offline Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file Windows 7 64bit Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file Office 2010 32bit
Novice
 
Join Date: Sep 2013
Posts: 3
jsuarezg is on a distinguished road
Default

Hello,

In the Data tab, click in edit links. You can change the linked workbook for the other you want or need.
Reply With Quote
  #3  
Old 09-27-2013, 10:14 AM
samsnov samsnov is offline Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file Windows 7 64bit Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file Office 2010 64bit
Novice
Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file
 
Join Date: Sep 2013
Posts: 4
samsnov is on a distinguished road
Default 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.
Reply With Quote
  #4  
Old 09-28-2013, 07:02 PM
BobBridges's Avatar
BobBridges BobBridges is offline Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file Windows 7 64bit Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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.
Reply With Quote
  #5  
Old 09-29-2013, 04:17 AM
samsnov samsnov is offline Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file Windows 7 64bit Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file Office 2010 64bit
Novice
Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file
 
Join Date: Sep 2013
Posts: 4
samsnov is on a distinguished road
Default

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.
Reply With Quote
  #6  
Old 09-29-2013, 04:24 AM
samsnov samsnov is offline Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file Windows 7 64bit Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file Office 2010 64bit
Novice
Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file
 
Join Date: Sep 2013
Posts: 4
samsnov is on a distinguished road
Default

I also wanted to mark this thread as solved but I didn't see the option to do that here.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft