After signing up for the $99 per year plan with Microsoft, I need to transfer workbooks from the 2008 Excel for Mac into the 2011 Excel for Mac. In trying to do this, everything comes across and looks good but doesn't operate as it should. For example, a new entry into a simple ledger sheet will not automatically add the new entry.

Any ideas of how "importing" the 2008 workbooks into the 2011 version workbooks needs to be done. Are there certain rules that need to be completed before a simple OPEN file is done in the 2011 version?