Excel 2010 Beta

Originally Posted by ChemistB

As far as this goes, nothing has changed between 2003 and 2007. I'm not sure about 2010. You begin in your "receiving" cell, type = and then move to your "transmitting" cell. The workbook/sheet references should automatically appear in the formula.

I know, and it isn't working the way it is supposed to! UGH!

EDIT

You gave me an idea...I closed the "transmitting" cell workbook(it was opened separately, i.e. not within the other so as to create an ability to jump from workbook to workbook in the "view" tab(in 2010)) and reopened it within the existing Excel that was already opened. Bam! It works. Not sure if that is a bug or not...but thanks a ton for the post that got me thinking differently.

I love this forum!