ExcelBanter - copy and paste

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - copy and paste (https://www.excelbanter.com/excel-discussion-misc-queries/169959-copy-paste.html)

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.

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.

patty wrote:

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