Excel 2010 - Workbook to Workbook Reference?


  1. Posts : 24
    Windows 7 Pro x64
       #1

    Excel 2010 - Workbook to Workbook Reference?


    I have two workbooks that I am using and I am trying to add one cell's data to another cell in another Excel workbook. It used to be as simple as beginning to "add" another cell's data(from another workbook you just migrate to the other workbook) into a different workbook. It isn't working like it used to in Excel 2003. Cant' speak of it for Excel 2007 as I never had it.

    Any thoughts on why it won't work? Any way to make it work?
      My Computer


  2. Posts : 966
    Windows 7 Ultimate 64-bit
       #2

    Lewiedude said:
    I have two workbooks that I am using and I am trying to add one cell's data to another cell in another Excel workbook. It used to be as simple as beginning to "add" another cell's data(from another workbook you just migrate to the other workbook) into a different workbook. It isn't working like it used to in Excel 2003. Cant' speak of it for Excel 2007 as I never had it.

    Any thoughts on why it won't work? Any way to make it work?
    Merging Data from Multiple Workbooks into a Summary Workbook in Excel

    Looks like it's possible.

    Also I would look at the DATA Tab under DATA TOOLS - CONSOLIDATE.
      My Computer


  3. Posts : 50
    Windows 7 Ultimate 64bit
       #3

    Have you tried copying the data, then paste it to what ever workbook you want. Do a PASTE SPECIAL and choose what ever you need. At least that is how it works in Excel 2003.
      My Computer


  4. Posts : 24
    Windows 7 Pro x64
    Thread Starter
       #4

    after trial and error, turns out you have to open any workbook you wish to link/reference cells from/to while in the desired 'linked' workbook. I had been launching Excel agian and opening additional workbooks as separate programs. No doubt this will have been taken care of prior to the RTM versin of office. thanks for the suggestions! I love this forum!
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 11:24.
Find Us