I cannot copy and paste between workbooks or use the format painter between
workbooks in excel 2007.

I don't think I am running multiple instances of excel. I have tried opening
excel and then dragging the two files into excel to open them.