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??