I have found that in Excel 2010, when a cell or set of cells is copied, the copy is not always an exact copy of the original, expecially for dates expressed as text ('9/10/11) most of the time it is copied as a date (9/10/11) and therefore my countif function does not count the text so formatted. It is the same with plain text, sometimes it needs an appostrophe and sometimes not, to be counted with the countif function. It is kind of distressing and can cause miscalculations that can be overlooked if not watched for and corrected. The spreadsheet is not strategic as it is for information only, however I do want the information to be accurate. The original sheet was setup in E2003, I don't really want to have to start all over by putting the data into a new sheet created in E2010 for the first time, with new formulas, etc. Even for my FY 2012 spreadsheet, I just copied an old one and deleted the data. With calculations and references and graphs it would have taken quite a bit of time to recreate the setup.
It could be something as simple as Excel not copying the data/formula as we needed or expected. I virtually always copy with ctl-c and paste with ctl-v, I don't use the F-Keys, I don't even know those shortcuts. I do drag and drop copying data and formulas and it does work most of the time.
O2010 has been a challenge to work with, I wasn't totally unaware of the ribbon menus after using them at home in O2007. Some of the commands have been moved from where they were in O2003 and it takes a while to find what you need. And sometimes it seems you can't do what you need anymore either. I do like the table functions in Outlook, as I hadn't seen that before, I guess it just did the table to text feature without a command before.