Copying functionality lost

[robertrkrueger]

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

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

I have not changed any settings on excel.

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

 

[JosephG]

I have the same (or similar) problem. I can no longer copy and paste
formula. 'Paste special' only offers unicode text or text. Fill dow
still works.
Workbook calc is set to automatic. Formats for both cells involved i
Copy and Paste are set to 'general'. Office Diagnostics found an
repaired 1 problem but after restarting excel my copy/paste issue stil
exists. One week ago I auto-updated to Microsoft Office Compatibilit
Pack Service Pack 3 (SP3) and The 2007 Microsoft Office Suite Servic
Pack 3 (SP3) but I'm not sure whether I used copy/paste functionalit
succesfully after that before I discovered the problem 5 days later.
This problem occurs with new workbooks that have no hidden sheets or no
Visual Basic. On user posted a similar problem that was reported to b
resolved using addins (by adding 'obetexcelvbacommon') but I haven'
found additional references to this and am reluctant to mess with i
unless I get further information.

Any suggestions? - Stumped.