Why am I no longer able to copy a worksheet within a file by using the right
click copy function? This used to work fine in Excel 2003. When I use it in
2007, I get error messages about a formula or sheet that contains the name
'_A' that already exists on the destination worksheet... If you click yes
this message goes on and on in some sort of loop that you cannot exit.

How can I get the copy worksheet function to work properly?