Ask Experts Questions for FREE Help !
Ask
    julimar's Avatar
    julimar Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Apr 30, 2008, 07:40 PM
    Spreadsheet link
    How to link one spreadsheet with another, so when entering data in one spreadsheet
    This data affect the another ones?
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    May 1, 2008, 04:09 PM
    Do you always want the data to flow ONE way? If so, you just need to create a cell-link from one sheet TO the other.

    For two spreadsheets in the SAME directory on your hard drive:
    • In spreadsheet one, called Book1, enter a value in cell A1 on Sheet1. Save it.
    • In spreadsheet two, called Book2, enter the formula =[Book2.xls]Sheet1!$A$1 in any cell and save it.
    • Now close both books
    • Open just Book2. It should ask if you want update external data, say YES.

    Any changes you make in Book1 will flow to Book2.

    Now, if the sheets are NOT in the same directory, you need to list the full path in the [ ] like =[C:\Temp\Book1.xls]Sheet1!$A$1

    Also, if you change the names of the sheets in the workbook, make sure you use the right formula... Sheet1 will change to whatever you named your sheet.
    PHXCrystal's Avatar
    PHXCrystal Posts: 2, Reputation: 1
    New Member
    		  
    #3

    Jan 20, 2011, 08:16 AM
    Comment on JBeaucaire's post
    Please forgive me, I'm rather new at formulas... I did try your answer step by step and it didn't work. I'm sure I missed something somewhere but am unable to tell where. Not enough room here to post specifics.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #4

    Jan 20, 2011, 08:26 AM

    You could try creating the "link" with the mouse instead.

    1) Open both workbooks
    2) In wb2 click on the cell you want to create the formula in
    3) Press the = sign to start the formula
    4) Now switch to wb1 and click on the cell you want to link to, and press ENTER
    5) You will now be back in wb2 with the new formula created for you by Excel.
    6) Repeat as needed.
    7) Close wb1 and the formulas in wb2 will update to include the full path for you.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

No spreadsheet [ 4 Answers ]

I have a new computer with windows vista. There is no spreadsheet with it like there used to be on computers. Is there a free way to get a spreadsheet system in my computer. I use spreadsheets some but not enough for me to buy anything to get it to work.

Excel Spreadsheet [ 2 Answers ]

Does anyone know how I can get an Excel spreadsheet to open at start-up? Thanks!

Spreadsheet file [ 1 Answers ]

Can't locate the file SKU112.CAB got any ideas?

Possible to link a spreadsheet 2 way [ 7 Answers ]

I know how to do a "one way" link in a spreadsheet. For example, if you change the value in A1, you can make it automatically change the value in A2 also. However, is there a way, if you change the value A2 that it will also change the value of A1? Thus, whichever you change, A1 or A2, will...

View more questions Search