Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2010 - Workbook to Workbook Reference?

30 Apr 2010   #1
Lewiedude

Windows 7 Pro x64
 
 
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 System SpecsSystem Spec
.
30 Apr 2010   #2
Johnathan Lyman

Windows 7 Ultimate 64-bit
 
 

Quote   Quote: Originally Posted by Lewiedude View Post
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 System SpecsSystem Spec
01 May 2010   #3
pweegar

Windows 7 Ultimate 64bit
 
 

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 System SpecsSystem Spec
.

01 May 2010   #4
Lewiedude

Windows 7 Pro x64
 
 

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 System SpecsSystem Spec
Reply

 Excel 2010 - Workbook to Workbook Reference?




Thread Tools




Similar help and support threads
Thread Forum
"save the changes” message after removing the protection from workbook
Some time ago I protected the Excel 2010 file from the path File > Protect workbook > Encrypt with password and gave it a password. Now that I removed that password via below method: Open the workbook and use Save As In the lower right of the file window will be "Tools" Choose "General...
Microsoft Office
Define names in workbook scope
Hello guys, I use MS Excel 2010. In this app, I know that using Formulas > Define names > define name it is possible to name a cell (or range). At that dialog box there is a scope rectangle which if I choose the entire sheets scope (workbook) so it's said that this name is valid for the entire...
Microsoft Office
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
Open Excel workbook in active window rather than first window
Hi, I have recently upgraded to Windows 7 and Office 2010 and though I'm starting to get used to all the changes there is one thing which is really bugging me. When I have two separate Excel windows open and open an Excel file from Windows Explorer the file will open in the first window not...
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Excel 2010
Hi all I'm trying to add a little Calculator function to a Spreadsheet I use for trading shares. I pull basic data from YAHOO finance and would like to have at the bottom of a spreadsheet a calculator which would allow me to enter Nr of shares bought, Price Paid and return things like Profit /...
Microsoft Office


Our Sites

Site Links

About Us

Find 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 21:47.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App