copy and paste

[patty]

I have an issue where I can only copy and paste one time into a new tab or
new excel sheet. It will not allow me to cntrl-C cntrl-V or to use the pick
list. Is there a setting I need to change or do I need to use the repair
function.

 

[Dave Peterson]

What happens when you try it?

It could be lots of things--maybe an event macro that's killing the clipboard?

If you open excel in safe mode:
close excel
windows start button|Run
Excel /safe

and then file|open your workbook

Does it work ok?

Opening excel in safe mode stops a lot of stuff from happening--that includes
stopping macros.