Excel 2010 - Workbook to Workbook Reference?

[Lewiedude]

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?

 

[Johnathan Lyman]

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.

 

[pweegar]

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.

 

[Lewiedude]

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!