Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I work between different spreadsheets, and I like to have one main workbook that links to certain cells in other workbooks.

For example, I will do a statement of business activities workbook that has all the business expenses listed, and then I will have individual workbooks for each expense account.

In the old excel, I would just put

=(and then go to the workbook that i wanted, and then select the cell i wanted and then hit enter)

and it would put the amount from that specific cell in my statement of business activities.

When I try to do that in excel 2010, I put the equals sign in the cell, and then go to the other workbook and find the cell I want, and when I hit enter, it just moves down a line and nothing happens in the other workbook.

How can I get this to work again, what do i need to do??

share|improve this question

1 Answer 1

Check if you have two instances of Excel running with a workbook open in each instance. If so, they won't be able to "communicate" with each other and you won't be able to create external links between them.

To fix this, you may either:

  • Close the other workbook. With only one instance remaining, use CTRL+O or File > Open to re-open the workbook that you've just closed.

    or

  • Close both workbooks first, open one and then when Excel is up, use CTRL+O or File > Open to launch the other one.

share|improve this answer
    
How do I open both in a single instance? –  Anna Jun 20 '12 at 21:13
    
@Anna Close the other workbook. With only one instance remaining, use CTRL+O or File>Open to re-open the workbook you just closed. –  Ellesa Jun 20 '12 at 21:25
    
@Anna You could also close both workbooks first, open one and then when Excel is up, use CTRL+O or File>Open to launch the other one. –  Ellesa Jun 20 '12 at 21:27
    
Thank you very much for your help!! It works now!! –  Anna Jun 20 '12 at 21:32
    
You're welcome. Feel free to accept this answer by clicking the 'check' mark to the left of this panel. (For more info: meta.stackexchange.com/a/5235) –  Ellesa Jun 20 '12 at 21:40

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.