Hi,
Perhaps a more pragmatic approach will bring us nearer to a solution which, in this case, might come with understanding what is going on.
1. You don't have any problem while copying (a) from one end of a sheet to the other and (b) from one worksheet to another within the same workbook. Please test and confirm.
2. You have the problem whenever you copy from one workbook to another. Always? No exceptions? If there are exceptions you should try to find reasons for why they are excepted.
3. You do NOT have a problem with Copy / Paste in any of the above cases. Please test and confirm.
4. You do have a problem with Copy / Paste Special and there are no exceptions within the boundaries established above. Correct?
5. If so, what are you copying? We need enough information about the nature of the data to think about why Excel should think that they are an object. Is the data volume big or small, a few lines or large sheets? Are there pictures in the data? What is the purpose of the Paste Special operation?
6. So, Excel is thinking that you want to paste an object. Is there a function for objects to be "Pasted special"? Can you post a screenshot of the dialog box you get to see? Have you identified the process to which that box belongs?
If you have made sure that your Excel is healthy and think that you can exclude viral actitivty then the place to look is probably the registry. I have a registry cleaner which, by its own acclaim, regularly fixes thousands of errors in my registry without the slightest bit of improvement on the part of my PC's performance. I doubt that such a gadget would find the source of your troubles - if it is in the registry. But if we can find out why Excel thinks of your innocent pastes as objects that might prompt some Regedit expert to point his finger at least in a general direction if not the precise line that might cause this wrong assessment.
I think Excel is a lot like children. They don't really make you happy, but life is, sure enough, awful without them, and God forbid that they should be sick.
Enjoy your Excel!
Have a great day!
Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)