A longtime user of excel 2007, yesterday I could no longer copy in my usual way. Colors, and indentation in cells were no longer copied. Likewise, I used to copy and paste to a multiple number of cells by dragging the paste. Now I get the message that the "data on the clipboard is not the same as the selected area." I can paste, but only 1 cell at a time.

This lack of copying functionality happens regardless of the individual excel file I use.

I have not changed any settings on excel.

I need help getting back to where I was.
Thank you.