SOLVED

Copy/paste no longer working in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-112995%22%20slang%3D%22en-US%22%3ECopy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-112995%22%20slang%3D%22en-US%22%3E%3CP%3ESometime%20in%20the%20last%20few%20months%20the%20copy%2Fpaste%20function%20within%20Excel%20(Office%20365%20version)%20stopped%20working%20for%20me.%26nbsp%3B%20I%20have%20updated%20Windows%20and%20all%20Office%20apps%20to%20the%20latest%20version%20but%20that%20hasn't%20fixed%20the%20problem.%26nbsp%3B%20I've%20also%20run%20the%20Office%20365%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20symptom%20is%20very%20strange.%26nbsp%3B%20When%20I%20hit%20Ctrl-C%20(or%20use%20the%20drop-down%20menus)%20on%20a%20cell%20in%20Excel%20the%20dashed%20lines%20that%20surround%20a%20cell%20selected%20for%20copying%20show%20up%20very%20briefly%20but%20immediately%20disappear.%26nbsp%3B%20If%20I%20go%20to%20another%20cell%20and%20paste%20it%20just%20puts%20a%20open%20parenthesis%20%22(%22%20in%20the%20cell.%26nbsp%3B%20Using%20Ctrl-X%20to%20cut%20exhibits%20similar%20behavior.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20repeatedly%20hit%20Ctrl-C%20it%20will%20occasionally%20work%20(the%20dashed%20lines%20remain%20and%20I%20can%20paste)%20but%20it%20typically%20takes%2015-20%20tries%20before%20it%20will%20work%20and%20if%20I%20try%20again%20it%20will%20fail.%26nbsp%3B%20This%20only%20seems%20to%20affect%20me%20when%20I%20try%20to%20copy%20cells.%26nbsp%3B%20If%20I%20select%20a%20cell%20and%20then%20edit%20the%20cell%20and%20manually%20select%20the%20content%20of%20the%20cell%20I%20can%20copy%20and%20paste%20with%20no%20issue.%26nbsp%3B%20It%20also%20appears%20to%20only%20be%20an%20issue%20when%20a%20cell%20is%20not%20empty.%26nbsp%3B%20If%20I%20select%20an%20empty%20cell%20I%20can%20copy%2Fpaste%20just%20fine.%26nbsp%3B%20If%20I%20select%20a%20cell%20that%20has%20been%20highlighted%20but%20has%20no%20content%20that%20also%20works%20properly.%26nbsp%3B%20It's%20only%20when%20there's%20text%20or%20a%20formula%20in%20the%20cell%20that%20this%20is%20an%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20only%20affects%20Excel%2C%20I%20haven't%20observed%20the%20issue%20in%20any%20other%20app.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-112995%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-382850%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-382850%22%20slang%3D%22en-US%22%3EI%20had%20this%20same%20issue%20on%20a%20single%20workbook%2C%20also%20corrected%20when%20I%20removed%20the%20ActiveSheet.Calculate%20code.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-382849%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-382849%22%20slang%3D%22en-US%22%3ENot%20necessarily.%20I%20found%20this%20problem%20trying%20to%20copy%2Fpaste%20on%20the%20same%20worksheet.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-319322%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-319322%22%20slang%3D%22en-US%22%3E%3CP%3EI%20just%20found%20out%20that%20if%20I%20%3CEM%3E%3CSTRONG%3E%22close%20my%20Adobe%20Acrobat%20XI%20Pro%22%3C%2FSTRONG%3E%3C%2FEM%3E%20program%20I%20was%20able%20to%20again%20copy%20and%20paste%20-%20I%20was%20also%20having%20the%20same%20issues%20from%20time%20to%20time%20-%20with%20Excel%20and%20with%20Word%20360.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps...%26nbsp%3B%20Ben%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-290826%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-290826%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20problem%20is%20with%20multiple%20worksheets%2C%20created%20by%20Excel%20due%20to%20problems%2C%20and%20Excel%20can't%20deal%20with%20changes%20in%20just%20one%20version.%3C%2FP%3E%3CP%3EThe%20solution%20is%20to%20look%20at%20any%20worksheet%20it%20wants%20to%20save%20under%20an%20alternate%20name%20and%20to%20save%20it%20as%20a%20replacement%20for%20the%20original%20worksheet%20if%20it%20is%20fine%2C%20or%20to%20save%20it%20under%20a%20different%20name%20and%20then%20eliminate%20it.%26nbsp%3B%20In%20any%20case%20eliminate%20saved%20duplicate%20files.%3C%2FP%3E%3CP%3EThen%20restart%20the%20program%2C%20choose%20your%20files%20from%20the%20file%20menu%20(File-Open-Browse)%2C%20not%20the%20list%20of%20previously%20opened%20files.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3ECopy%20from%20one%20worksheet%20to%20another%20-%20the%20problem%20should%20be%20gone.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-282745%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-282745%22%20slang%3D%22en-US%22%3E%3CP%3EJim's%20suggestion%20about%20making%20the%20%22calculate%20options%22%20automatic%20took%20care%20of%20this%20issue%20for%20me.%20I%20do%20not%20know%20how%20it%20got%20to%20manual%2C%20but%20it%20did.%20I%20had%20noticed%20that%20the%20formula%20was%20correctly%20being%20pasted%20but%20the%20data%20was%20not%20updating.%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-277140%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-277140%22%20slang%3D%22en-US%22%3E%3CP%3EClear%20temp%20files%20in%20user%20profile%20that%20is%20logged%20on%20%5C%5CUser%20name%5Cappdata%5Clocal%5CTemp.%20Clear%20all%20items%20there.%26nbsp%3B%20A%20shorter%20method%20to%20drill%20down%20to%20the%20folder%20is%20go%20to%20%22Run%22%20then%20enter%20%25temp%25%2C%20hit%20enter.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20clear%20the%20Windows%20Temp%20Files%26nbsp%3B%20%5C%5COSDisk%20(C)%20%5C%20Windows%5C%20Temp.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-275307%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-275307%22%20slang%3D%22en-US%22%3E%3CP%3EChange%20formula%20%22calculation%20options%22%20from%20manual%20to%20automatic.%26nbsp%3B%20Rumor%20has%20it%20that%20some%20obscure%20hotkey%20inadvertently%20hit%20may%20change%20this%20setting%20from%20%22automatic%22%20to%20%22manual.%26nbsp%3B%20Change%20it%20back%20to%20automatic.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-275078%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-275078%22%20slang%3D%22en-US%22%3E%3CP%3EComplete%20all%20your%20copy%20and%20paste%20activity.%26nbsp%3B%20Whenever%20you%20want%20the%20accurate%20results%20of%20your%20formulas%20recalculate%20the%20worksheet%20by%20%22%3CSTRONG%3E%3CEM%3ESelect%20cells%20that%20contain%20formulas%20you'd%20like%20to%20update.%20Press%26nbsp%3BCTRL%3C%2FEM%3E%3C%2FSTRONG%3E%3CSPAN%3E%3CSTRONG%3E%3CEM%3E%2B%20H%20.%20Find%20what%3A%20%3D%20Replace%20with%3A%20%3D%26nbsp%3B%3C%2FEM%3E%3C%2FSTRONG%3E%20%22%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-250901%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-250901%22%20slang%3D%22en-US%22%3EHi%20Jon%2C%20I%20had%20a%20similar%20issue.%20To%20my%20surprise%20I%20was%20able%20to%20fix%20it%20by%20simply%20highlighting%20the%20cell%20content%20and%20changing%20the%20color%20to%20black%3A%20on%20Home%20I%20clicked%20the%20icon%20A%20with%20color%20underneath%20and%20set%20the%20theme%20color%20to%20black.%20And%20abracadabra%20it%20worked.%20I%20know%20many%20moons%20passed%20by%20since%20you%20entered%20this%20ticket%20in%20the%20forum%20and%20probably%20you%20already%20fixed%20it.%20Anyway%20for%20future%20reference%20trying%20to%20help%20other%20users%2C%20as%20well.%3CBR%20%2F%3EThank%20you%2C%20Michael%20MasterLinguist%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-242614%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-242614%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20only%20trying%20to%20copy%20and%20paste%20from%20Notepad%20and%20Notepad%2B%2B%20and%20it's%20not%20working.%26nbsp%3B%20When%20I%20paste%20from%20Notepad%20to%20other%20programs%20(Word%2C%20Browser%2C%20etc.)%20it%20works%20fine%2C%20it%20only%20happens%20in%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-239515%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239515%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20is%20basically%20unusable%20for%20me%20for%20well%20over%20a%20year%20now%20as%20I%26nbsp%3Bhave%20to%20*really*%20need%20to%20process%20data%20by%20saving%20into%20a%20file%20instead%20of%20copy%2Bpasting%20it.%20I%20didn't%20realize%20it%20was%20such%20a%20widespread%20issue%20and%20if%20Microsoft%20isn't%20fixing%20it%20then%20I'm%20afraid%20I'll%20just%20have%20to%20ask%20for%20money%20back...%20it's%20just%20ridiculous%20-%20every%20time%20I%20want%20to%20paste%20I%20need%20to%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Open%20new%20blank%20spreadsheet%3C%2FP%3E%3CP%3E2.%20Only%20then%20copy%20from%20the%20other%20app%3C%2FP%3E%3CP%3E3.%20Paste%20into%20blank%20spreadsheet%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20a%20one%20time%20thing%20-%20next%20copy%2Bpaste%20-%20new%20spreadsheet%20is%20needed...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-228033%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-228033%22%20slang%3D%22en-US%22%3E%3CP%3EClearing%20the%20clipboard%20seems%20to%20work%20for%20me%20and%20other%20colleagues%20when%20encountering%20this%20problem.%20From%20the%20Home%20tab%2C%20click%20the%20little%20breakout%20icon%20next%20to%20%22Clipboard%22%20(underneath%20Format%20Painter)%2C%20then%20click%20Clear%20All%20in%20the%20Clipboard%20window.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-219955%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-219955%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20only%20experienced%20this%20issue%20(and%20many%20others)%20since%26nbsp%3B%20the%20company%20moved%20to%20Win%2010-%26nbsp%3B%20Office%20365%20-%20Office%202016%3C%2FP%3E%3CP%3EI%20have%20to%20say%20since%20we%20have%20made%20this%20move%2C%20i%20have%20more%20issues%20than%20i%20have%20ever%20experienced%20going%20right%20back%20to%20win%203.1%2C%20and%20before.%3C%2FP%3E%3CP%3EThe%20only%20solution%20I%20have%20found%20the%20works%20is%20save%20the%20file%20close%20it%20%26amp%3B%20open%20again.%3C%2FP%3E%3CP%3EI%20raised%20this%20isse%20with%20our%20retained%20IT%20maintanance%26nbsp%3B%20company%20have%20been%20unable%20to%20succesfully%20find%20a%20solution.%3C%2FP%3E%3CP%3EIt%20obviously%20something%20wrong%20with%20excel%20in%20its%20latest%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20a%20note%3C%2FP%3E%3CP%3EOne%20of%20my%20other%20laptops%20I%20have%20left%20with%2C%20win%207%20in%20%26amp%3B%20the%20previous%20office%2C%20I%20as%20yet%20have%20not%20experienced%20this%20issue%2C%20ever.%3C%2FP%3E%3CP%3Ep.s.%20since%20i%20rolled%20the%20last%20windows%2010%20update%20back%2C%20due%20to%20it%20interefering%20with%20Photoshop%20I%20experience%20%22cant%20copy%20%26amp%3B%20paste%22%20a%20lot%20less!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-219613%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-219613%22%20slang%3D%22en-US%22%3E%3CP%3ECopy%20and%20paste%20does%20not%20work%20in%20my%20excel%20either!%20%26nbsp%3B%20Hint%3A%20the%20copied%20cell%20has%20text%20with%20greek%20letters%20inserted%20via%20the%20windows%20character%20map.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-213405%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-213405%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20sorry%2C%20but%20this%20guidance%20is%20so%20unhelpful%20it%20is%20kind%20of%20unbelievable.%20Of%20%3CEM%3Ecourse%3C%2FEM%3E%20Ctrl%2BA%2C%20C%2C%20V%20worked%20for%20you%20--%20because%20you%20are%20not%20experiencing%20the%20issue!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESuggest%20the%20moderator%20delete%20these%20duplicate%20responses.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-213395%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-213395%22%20slang%3D%22en-US%22%3EThe%20Ctrl%20A%2C%20Ctrl%20C%2C%20then%20Ctrl%20V%20worked%20for%20me!!!%20Thx%20so%20much.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-213394%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-213394%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20%3CSPAN%3ECtrl%20A%2C%20Ctrl%20C%2C%20then%20Ctrl%20V%20worked%20for%20me!!!%20Thx%20so%20much.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-206699%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-206699%22%20slang%3D%22en-US%22%3E%3CP%3EI%20contacted%20Office%20365%20Support%20and%20they%20said.....%3C%2FP%3E%3CP%3EIn%20the%20recent%20Office%20365%20builds%20of%20Office%20they%20have%20removed%20this%20functionality%20of%20pasting%20multiple%20times%20with%20the%20%22Enter%22%20key.%20The%20only%20way%20to%20do%20this%20is%20using%20Ctrl%2BV.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205613%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205613%22%20slang%3D%22en-US%22%3E%3CP%3EI%20my%20case%20Excel%20opens%20my%20workbook%20with%20multiple%20sheets%20selected%20by%20default.%3C%2FP%3E%3CP%3EWhen%20i%20selected%20a%20range%20of%20cells%2C%20Excel%20copies%20the%20same%20range%20on%20multiple%20sheets.%3C%2FP%3E%3CP%3EExcel%20will%20not%20let%20you%20paste%20these%20cells%20into%20a%20single%20sheet.%3C%2FP%3E%3CP%3EDeselecting%20the%20other%20sheets%20solved%20it%20for%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-203051%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-203051%22%20slang%3D%22en-US%22%3E%3CP%3EAmazing.%20This%20worked%20for%20me.%20I%20had%20the%20copy%20and%20paste%20problem%20starting%20just%20recently.%20I%20open%20a%20blank%20excel%20file%2C%20type%20something%20in%20a%20cell%2C%20copy%20and%20then%20try%20to%20paste%20the%20cell%20elsewhere%20on%20the%20same%20sheet.%20After%20a%20few%20seconds%20excel%20is%20gone%2C%20closed%20down.%20I%20tried%20many%20of%20the%20solutions%20offered%20but%20nothing%20works.%20I%20even%20uninstalled%20office%20and%20reinstalled%20it.%20Same%20problem.%20I%20was%20skeptical%20whether%20this%20would%20work%20but%20after%20opening%20a%20blank%20TextPad%20file%2C%20typing%20something%20in%20it%2C%20then%20selecting%20it%20and%20pasting%20it%20twice%20back%20in%20the%20same%20file%2C%20the%20excel%20file%20was%20able%20to%20copy%20and%20paste.%20Does%20this%20show%20the%20problem%20has%20something%20to%20do%20with%20the%20clipboard%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20when%20I%20try%20to%20duplicate%20it%2C%20it%20doesn't%20work%20any%20more.%20So%20strange.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-202412%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-202412%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20did%20it%20for%20me%2C%20Im%20glad%20it%20was%20simple.%20Click%20on%20empty%20Cell%20and%20press%20ESC%20a%20few%20times%20and%20try%20again.%26nbsp%3B%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F138699%22%20target%3D%22_blank%22%3E%40Pg.%20Hj.%20Sahril%20PB%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3EI%20had%20this%20very%20same%20problem.%20I%20tried%20to%20copy%20and%20paste%20from%20a%20word%20document%20onto%20excel%20but%20wouldn%E2%80%99t%20work.%20Right%20clicking%20also%20didnt%20work%20as%20the%20drop%20down%20only%20appeared%20for%20less%20than%20a%20second%20and%20disappeared%20again.%20So%20I%20opened%20the%20clipboard%20and%20saw%20that%20i%20had%2024%20items%20of%20the%20same%20one%20in%20the%20clipboard.%20Tried%20to%20Clear%20All%20but%20to%20no%20avail.%3CBR%20%2F%3E%3CBR%20%2F%3EAnyway%2C%20i%20did%20this.%20I%20clicked%20on%20an%20empty%20cell.%20And%20on%20the%20keyboard%2C%20i%20pressed%20Escape.%20And%20that%20fixed%20it.%20That%E2%80%99s%20it!%20And%20i%20almost%20bought%20a%20new%20computer!%20Glad%20I%20didn%E2%80%99t!%20Phew!%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-200979%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-200979%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20having%20the%20same%20issue%20and%20found%20the%20below%20fix%20that%20worked%20for%20me%2C%202nd%20post%20from%20Gary%20McMaster.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.mrexcel.com%2Fforum%2Fexcel-questions%2F448364-lost-right-click-cut-copy-paste.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.mrexcel.com%2Fforum%2Fexcel-questions%2F448364-lost-right-click-cut-copy-paste.html%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-200023%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-200023%22%20slang%3D%22en-US%22%3EWhoa.%20Looks%20like%20this%20issue%20is%20going%20on%20since%20last%20October%2C%20with%20no%20resolution%20offered%20from%20Microsoft!%20I%20have%20the%20same%20problem.%20So%20far%20I%20was%20dealing%20with%20the%20annoying%20%22There%20is%20a%20problem%20with%20the%20Clipboard...%22%20message%20--%20even%20if%20Excel%202016%20was%20the%20only%20open%20program%20on%20my%20Windows%2010%20Pro%20PC%20at%20that%20time.%20Today%2C%20I%20find%20that%20even%20drag-and-drop%20copying%20is%20not%20working%20as%20expected.%20To%20be%20sure%2C%20the%20drag%20and%20drop%20works%2C%20but%20the%20selection%20and%20the%20cursor%20become%20non-responsive%20for%20several%20seconds.%20The%20only%20way%20I%20can%20get%20them%20to%20respond%20seems%20to%20be%20either%20click%20on%20another%20Excel%20file%2C%20or%20click%20on%20the%20Preview%20in%20the%20taskbar%20to%20get%20back%20to%20the%20same%20file.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20repair%20of%20Office%20programs%20did%20not%20work%20at%20all%2C%20and%20so%20far%20on%20my%20computer%2C%20this%20weird%20issue%20is%20restricted%20to%20Excel%202016%20only%20(Version%201805%3B%20Build%209330.2087%20Click-to-run).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-198093%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-198093%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20on%20the%20same%20boat%20as%20jervis.%20every%20time%20I%20do%20Ctrl%2BC%2C%20the%20Ctrl%2BV%20result%20is%20always%20opening%20parentheses%20%22(%22.%20The%20funny%20thing%20is%20that%20it%20also%20happened%20on%20LibreOffice%20Calc.%20So%20I%20suspect%20it's%20not%20MS%20Excel%20problem.%3C%2FP%3E%3CP%3EClearing%20the%20Clipboard%20content%20sometimes%20helped%2C%20but%20not%20all%20the%20time.%3C%2FP%3E%3CP%3EAny%20clue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-193733%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-193733%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20just%20come%20across%20this%20issue%20in%20Excel%20on%20a%20colleague's%20computer%2C%20running%20Windows10.%3C%2FP%3E%3CP%3EWhat%20we%20found%20as%20a%20workaround%20was%20that%20selecting%20the%20required%20range%2C%20holding%20Ctrl%20and%20dragging%20the%20entire%20frame%20from%20workbook%20A%20to%20workbook%20B%20successfully%20copied%20the%20range.%20It%20helped%20that%20we%20were%20working%20on%20a%20dual%20screen.%3C%2FP%3E%3CP%3ENormal%20copy%20%26amp%3B%20paste%2C%20using%20either%20Ctrl%2BC%2FCtrl%2BV%20or%20right%20click%20did%20not%20work.%20As%20soon%20as%20we%20clicked%20on%20workbook%20B%2C%20the%20dotted%20lines%20from%20workbook%20A%20disappeared%20and%20the%20paste%20function%20reverted%20to%20pasting%20some%20text%20that%20had%20been%20copied%20elsewhere%20earlier%20in%20the%20day.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-191687%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-191687%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20had%20similar%20issues%20in%20the%20desktop%20version%20of%20Microsoft%20Office%20Professional%20Plus%202010.%26nbsp%3B%20I%20first%20noticed%20that%20Excel%20would%20not%20drag-and-drop%20from%20cell%20to%20cell.%20I%20couldn't%20paste%20in%2C%20any%20capacity%2C%20within%20a%20workbook%20either.%20However%2C%20I%20could%20copy%20from%20Excel%20and%20Paste%20to%20another%20program(BluBeam%2FAdobe)%2C%20just%20not%20another%20Office%20program.%20Which%20lead%20me%20to%20discover%20the%20problem%20existed%20across%20all%20the%20Office%20programs%20I%20had%20open.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20%3CSTRONG%3Eclosed%20ALL%20Microsoft%20Office%20programs%3C%2FSTRONG%3E%20and%20re-opened%20them%20and%20the%20copy-paste%20functionality%20returned%20for%20all%20of%20them.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-191254%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-191254%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20worked%20for%20me-going%20to%20the%20clipboard.%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-183675%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-183675%22%20slang%3D%22en-US%22%3EI%20had%20this%20very%20same%20problem.%20I%20tried%20to%20copy%20and%20paste%20from%20a%20word%20document%20onto%20excel%20but%20wouldn%E2%80%99t%20work.%20Right%20clicking%20also%20didnt%20work%20as%20the%20drop%20down%20only%20appeared%20for%20less%20than%20a%20second%20and%20disappeared%20again.%20So%20I%20opened%20the%20clipboard%20and%20saw%20that%20i%20had%2024%20items%20of%20the%20same%20one%20in%20the%20clipboard.%20Tried%20to%20Clear%20All%20but%20to%20no%20avail.Anyway%2C%20i%20did%20this.%20I%20clicked%20on%20an%20empty%20cell.%20And%20on%20the%20keyboard%2C%20i%20pressed%20Escape.%20And%20that%20fixed%20it.%20That%E2%80%99s%20it!%20And%20i%20almost%20bought%20a%20new%20computer!%20Glad%20I%20didn%E2%80%99t!%20Phew!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-182618%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-182618%22%20slang%3D%22en-US%22%3E%3CP%3EI%20hope%20they%20can%20fix%20this%20but%20in%20the%20mean%20time%20this%20was%20my%20work%20around%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%26nbsp%3B%20Make%20Clipboard%20visible%20under%20Home%20tab%3C%2FP%3E%3CP%3E2.%26nbsp%3B%20Highlight%20what%20you%20would%20like%20to%20copy%20%2F%20paste%20and%20you%20will%20see%20it%20show%20up%20in%20clipboard%3C%2FP%3E%3CP%3E3.%26nbsp%3B%20Select%20the%20cell%20where%20you%20want%20the%20info%20to%20be%20pasted%20on%26nbsp%3B%3C%2FP%3E%3CP%3E4.%26nbsp%3B%20don't%20press%20Ctrl%2BV%2C%20instead%20press%20the%20actual%20item%20on%20the%20clipboard%20menu%20and%20the%20items%20will%20be%20pasted%20on%20the%20selected%20cell.%20Note%3A%20it%20will%20be%20pasted%20without%20formats.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAgain%20if%20someone%20else%20can%20figure%20out%20this%20issue%20that%20would%20be%20great%2C%20but%20in%20the%20mean%20time%20these%20steps%20have%20worked%20every%20time.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-182367%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-182367%22%20slang%3D%22en-US%22%3E%3CP%3EI%20got%20mine%20to%20work...%20(copying%20from%20Excel%20to%20Smartsheet%20(Safari)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20used%20paste%20and%20match%20style%20from%20the%20Edit%20Menu%20when%20CMD-V%20would%20not%20work...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-180525%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-180525%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20having%20the%20same%20issue%20as%20the%20original%20post%2C%20although%20after%20reading%20the%20thread%20I%20realized%20I%20had%20also%20lost%20the%20ability%20to%20drag%20down%20from%20two%20cells%20containing%201%20and%202%20respectively%20and%20have%20Excel%20complete%20a%20series%3A%20instead%2C%20all%20the%20cells%20in%20the%20range%20now%20had%201...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECopy%26amp%3Bpaste%20didn't%20work%20in%20just%20one%20specific%20workbook%2C%20let's%20call%20it%20the%20%22failing%20workbook%22.%20I%20had%20a%20few%20more%20open%20at%20the%20same%20time%3A%20copy%2Fpaste%20worked%20fine%20in%20all%20the%20others.%20I%20could%20even%20copy%20in%20the%20failing%20workbook%20and%20paste%20correctly%20in%20another%20one.%20It%20was%20only%20in%26nbsp%3Bthe%20failing%20workbook%20that%20if%20I%20selected%20a%20cell%20(or%20a%20range%20of%20cells)%2C%20copied%20them%2C%20and%20as%20soon%20as%20I%20clicked%20on%20a%20new%20cell%20the%20dashed%20lines%20would%20disapear%20and%20there%20was%20nothing%20left%20to%20paste.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESame%20as%20the%20original%20post%2C%20I%20was%20able%20to%20copy%20and%20paste%20the%20text%20content%20from%20one%20cell%20to%20another.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20an%20occasional%20Excel%20user%3A%20the%20only%20thing%20that%20was%20different%20between%20the%20failing%20workbook%20and%20the%20rest%20of%20them%20is%20that%20it%20contained%20macros.%20I%20don't%20fully%20understand%20the%20code%2C%20I%20copied%20it%20from%20a%20googled%20example%20and%20adapted%20it%20to%20my%20particular%20needs.%20The%20macros%20I%20copied%20count%20the%20number%20of%20coloured%20cells%20in%20a%20range.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhile%20writing%20this%20reply%20I%20tried%20duplicating%20the%20file%20and%20removing%20the%20macro%20module%20on%20the%20copy.%3C%2FP%3E%3CP%3ECopy%26amp%3Bpaste%20worked%20immediately%20after.%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20this%20I%20looked%20into%20the%20macros%20and%20saw%20that%20I%20had%20pasted%20the%20following%20code%20in%20the%26nbsp%3BThisWorkbook%20option%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3EOption%20Explicit%0A%0A'%0A'%20http%3A%2F%2Fwww.myonlinetraininghub.com%2Fcount-sum-and-average-colored-cells%0A'%0A%0APrivate%20Sub%20Workbook_SheetSelectionChange(ByVal%20Sh%20As%20Object%2C%20ByVal%20Target%20As%20Range)%0A%0A%20%20%20%20'Uncomment%20the%20next%20line%20if%20you%20want%20to%20make%20Excel%20recalculate%20the%20ActiveSheet%20every%20time%20the%20Selection%20changes%0A%20%20%20%20ActiveSheet.Calculate%0A%20%20%20%20%0AEnd%20Sub%3C%2FPRE%3E%3CP%3ESo%20I%20did%20comment%20back%20the%20ActiveSheet.Calculate%20line%2C%20and%20copy%26amp%3Bpaste%20worked%20once%20again%20!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20for%20folks%20who%20are%20having%20the%20issue%20in%20any%20workbook%2C%20the%20problem%20could%20be%20triggered%20by%20having%20a%20start%20macro%20with%20some%20command%20such%20as%20the%20line%20I%20showed...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20dragging%20issue%26nbsp%3Bmust%20be%20another%20problem%26nbsp%3Bbecause%20it%20seemed%20to%20happen%20in%20all%20my%20workbooks%2C%20not%20only%20in%20the%20failing%20one.%26nbsp%3BHowever%20after%20closing%20Excel%20and%20reopening%20just%20the%20failing%20workbook%2C%20dragging%201%2C2%20to%20get%20a%20series%20was%20once%20again%20working%2C%20both%20in%20the%20failing%20workbook%20and%20in%20another%20fresh%20one%20I%20opened.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20could%20not%20get%20it%20to%20fail%20again...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps%20somebody%20at%20Microsoft%20look%20into%20both%20issues...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-179018%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-179018%22%20slang%3D%22en-US%22%3E%3CP%3EAdd%20me%20to%20the%20list.%20Some%20copy%2Fpaste%20function%20work%2Csome%20do%20not.%20This%20started%20recently.%26nbsp%3B%20Specifically%20I%20was%20trying%20to%20copy%20formulas%20from%20a%20range%20of%20cells%20to%20paste%20into%20another%20range.%20Some%20cells%20had%20formulas%2C%20others%20only%20had%20values.%20When%20attempting%20to%20'paste%20formulas'%2C%20Excel%26nbsp%3Bwould%20only%20perform%20a%20basic%20'paste'%20of%20%3CEM%3Eall%3C%2FEM%3E%20the%20data%20in%20the%20copy-from%20range%2C%20thus%20overwriting%20the%20values%20in%20the%20target%20range.%26nbsp%3B%20I%20tested%20with%20different%20files%20on%20three%20separate%20machines.%20One%20desktop%26nbsp%3Band%20one%20tablet%20both%20running%20Office%20365%20desktop%20versions%20of%20Excel%202016%2C%20and%20one%20other%20desktop%20running%20Excel%202010.%26nbsp%3B%20Same%20problem%20in%20all.%26nbsp%3B%20Their%20are%20two%20common%20denominators%3A%20All%20three%20systems%20are%20running%20windows%2010%20(two%20running%20Pro%2C%20one%20running%20Home)%2C%20and%20all%20the%20files%20tested%20were%20last%20modified%20using%20Excel%202016.%20I've%20tried%20all%20the%20solutions%20posted%20here%20so%20far%20-%20no%20joy.%20I%20did%20the%20feedback%20to%20MS%20are%20requested.%20Surely%20hope%20this%20get%20a%20solution%20quickly.%20Productivity%20is%20being%20killed!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-178748%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-178748%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20That's%20essentially%20what%20I%20have%20been%20doing.%20It%20seems%20to%20work%20now%20so%20either%20you%20fixed%20Excel%20over%20breakfast%20or%20it%20was%20my%20finger%20trouble....%3C%2FP%3E%0A%3CP%3ELet's%20close%20this%20for%20now%20and%20I'll%20see%20if%20it%20continues%20to%20work.%20I%20had%20this%20same%20problem%20last%20month%20where%20it%20didn't%20work%20(as%20you%20illustrated)%20but%20then%20it%20did%20work%20later.%20Hope%20it's%20not%20an%20intermittent%20problem%20-%20they%20are%20the%20worst%20kind%20to%20fix.%3C%2FP%3E%0A%3CP%3EMany%20thanks%2C%20Ian%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-178734%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-178734%22%20slang%3D%22en-US%22%3E%3CP%3EI%20think%20you%20need%20to%20highlight%20first%20then%20drag%20across%20from%20the%20corner%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20804px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F31416iDD22E0D1A969AC94%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Highlight%20Then%20Drag.gif%22%20title%3D%22Highlight%20Then%20Drag.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-178732%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-178732%22%20slang%3D%22en-US%22%3E%3CP%3ENo%2C%20it's%20one%20seamless%20mouse%20operation.%20I%20position%20the%20mouse%20on%20the%20bottom%20right%20corner%20of%20the%20top%20cell%20to%20be%20selected%20then%20move%20the%20mouse%20down%20to%20select%20the%20required%20cells%2C%20At%20the%20bottom%20cell%20I%20move%20the%20mouse%20over%20to%20the%20adjacent%20column%20and%20it%20should%20copy%20the%20old%20contents%20into%20the%20new%20column.%20Now%20it%20copies%20the%20contents%20of%20the%20top%20cell%20into%20all%20the%20lower%20cells%20and%20doesn't%20attempt%20to%20copy%20them%20into%20the%20adjacent%20column.%20The%20cursor%20displays%20a%20bold%20cross%20and%20doesn't%20change%20shape%20when%20selecting%20cells%20or%20trying%20to%20move%20the%20cells.%20It%20used%20to%20display%20a%20different%20cursor%20during%20this%20copy%20operation.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-178726%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-178726%22%20slang%3D%22en-US%22%3EHi%20Ian%2C%20%20are%20you%20doing%20Right%20Click%20Copy%20then%20moving%20and%20doing%20Right%20Click%20paste%20or%20something%20different%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-178714%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-178714%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20a%20novice%20user%20I%20think%20I%20have%20the%20same%20problem.%20I%20am%20trying%20to%20copy%20a%20range%20of%20cells%20in%20a%20column%20to%20the%20adjacent%20column%20(%20ie%20next%20month).%20I%20used%20to%20be%20able%20to%20do%20this%20with%20one%20mouse%20operation%20-%20select%20the%20cell%20range%20then%20move%20over%20to%20the%20next%20column%20and%20it%20would%20copy%20that%20range.%20Now%20that%20doesn't%20work.%20It%20changes%20the%20content%20of%20each%20selected%20cell%20to%20the%20first%20(top)%20cell.%20This%20is%20definitely%20something%20that%20has%20changed%20or%20a%20parameter%20that%20I've%20changed%20but%20I%20don't%20know%20what.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-171609%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-171609%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20problem%20is%20just%20because%20you%20have%202%20instances%20of%20EXCEL.EXE%20and%20you%20want%20to%20copy%20paste%20from%20one%20instance%20to%20another.%20You%20can't%20copy%20paste%20values%20for%20example.%20You%20can%20see%20that%20from%20your%20Start%20Task%20Manager.%20In%20excel%202010%20any%20workbook%20opened%20from%20explorer%20was%20opened%20from%20the%20last%20application%20opened.%20In%20365%20they%20try%20but%20from%20my%20experience%20sometimes%20fails%20to%20open%20all%20of%20them%20in%20only%20one%20application.%3C%2FP%3E%0A%3CP%3EA%20solution%20is%20to%20open%20that%20excel%20file%20using%20File-%26gt%3BOpen%20commands%20inside%20your%20application%20and%20not%20double-clicking%20an%20excel%20file%20from%20explorer.%20I%20hope%20this%20helps.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-170434%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-170434%22%20slang%3D%22en-US%22%3EI%20have%20the%20same%20issue%2C%20have%20not%20managed%20to%20find%20the%20root%20cause%20as%20yet%20but%20do%20have%20a%20simple%20workaround%20that%20gets%20it%20working%20again!%3CBR%20%2F%3E%20%3CBR%20%2F%3EOpen%20notepad%20or%20an%20email%20or%20probably%20anything%20else%20with%20some%20text%20in%20it%20%2C%20press%20Ctrl%20A%2C%20Ctrl%20C%2C%20then%20Ctrl%20V.%20%20then%20go%20back%20to%20Excel%20and%20Copy%20and%20Paste%20will%20be%20working%20again%20!%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-170178%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-170178%22%20slang%3D%22en-US%22%3EI%E2%80%99d%20recommend%20that%20everyone%20having%20thus%20issue%20goes%20to%20File%20%26gt%3B%20Feedback%20and%20send%20a%20frown%2C%20putting%20your%20details%20in%20the%20section%20and%20start%20it%20%5BCan%E2%80%99t%20Copy%20Paste%5D%3CBR%20%2F%3E%3CBR%20%2F%3EAlso%20what%20version%20is%20everyone%20in%20who%E2%80%99s%20having%20this%20problem%20%3F%20%20File%20%26gt%3B%20Account%20%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20will%20read%20something%20like%20%3CBR%20%2F%3ESemi%20Annual%20Channel%3CBR%20%2F%3EBuild%201234.567%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-169606%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-169606%22%20slang%3D%22en-US%22%3E%3CP%3EOK%2C%20guys%20none%20of%20these%20fixes%20worked%20for%20me.%20This%20just%20started%20for%20me%20today.%20In%20too%20different%20instances.%20When%20I%20copy%20the%20formula%20into%20another%20cell%20from%20another%20spreadsheet%2C%20the%20formula%20shows%2C%20but%20the%20result%20in%20the%20result%20from%20the%20cell%20I%20copied%20it%20from.%20he%20only%20that%20has%20worked%20is%20by%20going%20to%20%3CEM%3Einsert%20function%3C%2FEM%3E%20in%20each%20cell%20to%20%22activate%22%20the%20formula.%26nbsp%3B%20I%20can't%20do%20this%20for%20hundreds%20of%20rows.%20How%20did%20I%20break%20Excel%20and%20what%20can%20I%20do%20to%20fix%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-167529%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-167529%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20found%20the%20problem%20with%20copying%20from%20Excel%20cloud%20and%20to%20a%20local%20MAC%20screen%20i.e.%20a%20multi%20cell%20with%20a%20value%20to%20say%20notes.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20solution%20which%20is%20not%20one%2C%20but%20highlights%20the%20issue%2C%20is%20that%20you%20can%20double%20click%20on%20a%20value%20in%20Excel%20and%20copy%20from%20the%20bar%2C%20as%20below%20and%20it%20works%20%3Aweary_face%3A%20but%20if%20I%20try%20and%20access%20and%20copy%20directly%20from%20the%20CELL%20it%20does%20not%20work%20at%20all%2C%20which%20is%20the%20existing%20problem.%20Not%20really%20a%20workaround%2C%20but%20does%20highlight%20what%20is%20going%20on%20!!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CIMG%20src%3D%22blob%3Ahttps%3A%2F%2Ftechcommunity.microsoft.com%2F0fdf1e03-67c9-41b7-85b3-7a58b02f9c8d%22%20border%3D%220%22%20width%3D%22196%22%20height%3D%22262%22%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-167350%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-167350%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20had%20this%20same%20issue%20and%20was%20disappointed%20to%20get%20to%20the%20bottom%20of%20the%20page%20with%20no%20answer.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHowever%2C%20upon%20saving%20%26amp%3B%20closing%20the%20most%20recent%20workbook%20I%20was%20working%20on%2C%20the%20copy%20paste%20functionality%20was%20restored%20in%20the%20new%20sheet%20I%20was%20working%20on%20that%20lost%20the%20ability%20to%20copy%2Fpaste.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20is%20really%20frustrating%2C%20but%20I%20think%20all%20we%20need%20to%20do%20is%20be%20a%20bit%20more%20organized%20and%20not%20leave%20workbooks%20open%20that%20we're%20not%20working%20on.%20That's%20my%20new%20protocol%20anyway.%20Hope%20this%20helps.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-164636%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-164636%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20had%20this%20same%20issue%20in%20all%20Microsoft%20Office%20products%2C%20and%20I%20just%20had%20the%20same%20issue%20happen%20in%20OpenOffice%20Draw!%20It%20seems%20to%20happen%26nbsp%3Bwith%20a%20document%20that%20I%20have%20been%20editing%20over%20and%20over%20again.%20Opening%20a%20new%20document%20does%20not%20seem%20to%20help%20the%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-153605%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-153605%22%20slang%3D%22en-US%22%3E%3CP%3EI%20had%20the%20same%20problem.%20The%20only%20way%20I%20could%20copy%20cells%20was%20text%20only%20via%20the%20clipboard.%3C%2FP%3E%0A%3CP%3EThe%20solution%20for%20me%20was%20to%20disable%20(comment%20out)%20all%20macros%20and%20VB%20content%20I%20generated%20for%20that%20particular%20page.%26nbsp%3B(I%26nbsp%3Buse%20a%20nifty%20little%20bit%20of%20code%20to%20insert%20the%20contents%20of%20a%20cell%20into%20the%20footer%20of%20the%20page.)%3C%2FP%3E%0A%3CP%3EI%20did%20my%20copying%20and%20once%20the%20page%20was%20working%20I%20removed%20the%20comment%20ticks%20and%20everything%20worked.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHope%20this%20helps..%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-152178%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-152178%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20had%20the%20same%20problem%2C%20complicated%20by%20the%20%22excel%20not%20responding%22%20issue.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20an%20effort%20to%20solve%20that%20problem%2C%20I%20changed%20some%20settings%20under%20options.%3C%2FP%3E%0A%3CP%3EWell%2C%20then%20my%20large%20workbook%20quit%20behaving%20nice.%26nbsp%3B%20I%20would%20copy%20a%20row%20to%20one%20or%20more%20rows%20and%20all%20I%20got%20was%20the%20results%20from%20the%20copy%20reappearing%20in%20the%20new%20rows.%3C%2FP%3E%0A%3CP%3EWell%2C%20that%20was%20cured%20with%20switching%20the%20calculations%20from%20manual%20to%20automatic.%26nbsp%3B%20Fixed%20the%20copy%20paste%20problem!%26nbsp%3B%20Did%20I%20feel%20dumb%3F%26nbsp%3B%20You%20bet.%26nbsp%3B%20I%20faintly%20remember%20using%20the%20manual%20calculation%20on%20a%20large%20worksheet%20from%2020%20years%20ago...%3C%2FP%3E%0A%3CP%3ENow%20onto%20the%20%22excel%20not%20responding%22%20issue.%26nbsp%3B%20I've%20been%20trying%20to%20dump%20tons%20of%20formatting%20(color%2C%20borders%2C%20etc.)%20and%20checking%20for%20those%20stray%20columns%2Frows%20that%20had%20accidental%20formatting.%26nbsp%3B%20I%20saw%20that%20in%20one%20of%20my%20searches%20on%20google.%26nbsp%3B%20It%20seems%20to%20help%2C%20except%20in%20the%20process%2C%20the%20message%20comes%20up%20again%20and%20sometimes%20doesn't%20clear%20for%20hours%2C%20even%20overnight.%26nbsp%3B%20It's%20hard%20to%20dump%20formatting%20if%20you%20can't%20access%20the%20file%20and%20save%20your%20changes.%26nbsp%3B%20I%20have%20been%20dealing%20with%20recovered%20files%2C%20multiple%20saves%20and%26nbsp%3Bso%20on.%26nbsp%3B%20Sigh...%26nbsp%3B%20I%20may%20have%20to%20start%20over%20with%20these%20files%20and%20recreate%20them.%26nbsp%3B%20They%20are%20great%20grade%20calculators%2C%20with%20a%20sheet%20for%20each%20area%20(homework%2C%20attendance%2C%20quizzes%2C%20etc.)%20and%20pull%20into%20a%20summary%20page%20for%20final%20results.%26nbsp%3B%20Lots%20of%20%22vlookup%22%20action%20between%20sheets.%26nbsp%3B%20The%20fancy%20formatting%20with%20colors%2C%20borders%2C%20boxes%20helped%20to%20avoid%20errors%20with%20data%20entry.%26nbsp%3B%20I%20teach%20large%20classes%20(100%2B)%20and%20this%20has%20evolved%20with%20each%20graduate%20assistant%2C%20computer%2C%20software%20change%20over%20the%20past%2015%20years.%20Probably%20quite%20a%20patchwork%20job%20by%20now.%26nbsp%3B%20I%20might%20be%20on%20the%20road%20to%20sanity%20if%20all%20of%20this%20works.%3C%2FP%3E%0A%3CP%3EI%20hope%20the%20manual%20to%20automatic%20switch%20in%20calculations%20works%20for%20you.%26nbsp%3B%20Good%20luck.%26nbsp%3B%20%26nbsp%3B%20-%26nbsp%3B%20Marie%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149896%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149896%22%20slang%3D%22en-US%22%3EIn%20that%20case%20I%20am%20out%20of%20ideas%20I'm%20afraid!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149765%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149765%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Jan%2C%20none%20of%20the%20methods%20work.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBelow%20is%20a%20sample%20of%20my%20freshly%20formatted%20PC%20and%20freshly%20installed%20Microsoft%20Office%202016.%3CBR%20%2F%3E%3CBR%20%2F%3EWhat%20I%20did%20was%3A%3CBR%20%2F%3E1)%20Select%20the%20A%20cell%20and%20press%20Ctrl%2BC%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E2)%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3ES%3C%2FSPAN%3E%3CSPAN%3Eelect%20the%26nbsp%3BB%20cell%20and%20press%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3EC%3C%2FSPAN%3E%3CSPAN%3Etrl%2BC%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E3)%26nbsp%3BSelect%20the%26nbsp%3BC%20cell%20and%20press%26nbsp%3BCtrl%2BC%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20371px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F27588iADD75FFE24E425A4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222jds8q1%22%20title%3D%222jds8q1%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20you%20can%20see%2C%20there%20is%20this%20bracket%20(%20somehow%20automatically%20copied%20on%20top%26nbsp%3Bof%20the%20A%2FB%2FC%20selections.%20This%20is%20really%20weird..%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149750%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149750%22%20slang%3D%22en-US%22%3EDo%20the%20suggestions%20by%20jbosari%20on%20this%20page%20help%3F%20%3CA%20href%3D%22http%3A%2F%2Fwww.tomsguide.com%2Fforum%2F244522-49-excel-copy-paste-issue-help%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.tomsguide.com%2Fforum%2F244522-49-excel-copy-paste-issue-help%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149618%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149618%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Jon%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20have%20the%20exact%20same%20problem%20on%20both%20my%20surface%20pro%204%20and%20on%20my%20freshly%20formatted%20desktop%20pc.%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20Excel%202016%2C%20I%20cannot%20copy%20any%20cells.%20The%20dashed%20lines%20will%20show%20briefly%20and%20then%20disappears..%20A%20copied%20cell%20usually%20have%20the%20dashed%20lines%20circling%20it%20all%20the%20time.%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20I%20try%20to%20paste%2C%20a%20left%20bracket%20shows%20up.%20%22%26nbsp%3B%20(%26nbsp%3B%20%22%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECan%20anyone%20help%20us%20solve%20this%20mysterious%20problem..%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-134010%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-134010%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20also%20in%20the%20same%20boat.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExcel%20in%20Windows%2010%20slows%20down%20very%20frequently%2C%20even%20when%20only%201%20workbook%20with%20no%20complex%20formulas%20is%20open.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20copy%2Fpaste%20function%20for%20cells%20is%20intermittent%20at%20best%2C%20you%20cannot%20copy%20a%20formula%20across%20multiple%20cells%20like%20you%20could%20in%20the%20past%2C%20and%20another%20unrelated%20issue%3A%20you%20can't%20delete%20a%20column%20or%20row%20that%20is%20under%20a%20merged%20cell%20at%20the%20beginning%20of%20the%20column%20or%20row%20like%20you%20could%20in%20the%20past.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-132066%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-132066%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20in%20the%20same%20boat.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20can%20copy%2Fpaste%20from%20Excel%2C%20to%20Excel.%3C%2FP%3E%0A%3CP%3EI%20am%20unable%20to%20copy%2Fpast%20from%20OneNote%20to%20Excel.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20function%20was%20working%20fine%20a%20couple%20of%20weeks%20ago%2C%20and%20now%20it%20is%20not.%20I%20am%20also%20noticing%20a%20latency%20in%20Excel%20across%20all%20files.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-127352%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-127352%22%20slang%3D%22en-US%22%3EI%20had%20a%20similar%20issue%2C%20I%20copied%20a%20selection%20of%20rows%20to%20the%20clipboard%2C%20then%20tried%20to%20paste%20in%20a%20single%20cell%20below%20where%20I%20copied%20from%20and%20got%20the%20error%20%22You%20can't%20paste%20here%20because%20the%20copy%20area%20and%20paste%20area%20aren't%20the%20same%20size.%20Select%20just%20one%20cell%20in%20the%20paste%20area%20or%20an%20area%20that's%20the%20same%20size%2C%20and%20try%20pasting%20again.%22%3CBR%20%2F%3EIt%20turned%20out%20that%20I%20wasn't%20scrolled%20all%20the%20way%20over%2C%20so%20column%20A%20wasn't%20showing%20and%20I%20was%20trying%20to%20paste%20the%20selection%20starting%20with%20column%20B%20at%20the%20row%20of%20the%20currently%20highlighted%20cell.%20I%20just%20needed%20to%20scroll%20over%20horizontally%20select%20the%20cell%20in%20column%20A%2C%20and%20press%20Enter%20or%20Ctrl-V%20to%20paste.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-115637%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-115637%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%20for%20the%20delayed%20response%2C%20for%20some%20reason%20I%20didn't%20get%20a%20notification%20about%20another%20post%20so%20I%20just%20saw%20it%20when%20I%20came%20back%20and%20checked%20manually.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20definitely%20not%20a%20keyboard%20issue.%26nbsp%3B%20I%20have%20the%20same%20problem%20at%20home%20and%20at%20work%20and%20regardless%20of%20whether%20I'm%20using%20a%20docking%20station%20with%20external%20keyboard%20or%20built-in%20laptop%20keyboard.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20other%20ideas%3F%26nbsp%3B%20Excel%20is%20basically%20worthless%20if%20you%20can't%20copy%20and%20paste%20cells.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-114638%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-114638%22%20slang%3D%22en-US%22%3EAny%20chance%20your%20keyboard%20has%20a%20problem%3F%20e.g.%20if%20the%20Escape%20key%20is%20pressed%2C%20the%20clipboard%20is%20emptied%20in%20Excel%20when%20a%20cell%20is%20copied%2C%20but%20not%20if%20you%20copy%20the%20text%20of%20a%20comment.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-113905%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-113905%22%20slang%3D%22en-US%22%3E%3CP%3ECorrect%2C%20I%20don't%20think%20that's%20the%20case.%26nbsp%3B%20I'm%20not%20getting%20an%20error%20that%20the%20clipboard%20is%20locked%20and%20the%20clipboard%20still%20functions%20correctly.%26nbsp%3B%20ex.%20if%20I%20edit%20a%20comment%20I%20can%20select%20text%2C%20copy%2C%20and%20paste%20it%20inside%20or%20outside%20of%20excel%20just%20like%20I%20can%20select%20a%20formula%20in%20a%20cell%20and%20copy%2Fpaste%20it.%26nbsp%3B%20I%20just%20can't%20copy%2Fpaste%20a%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-113884%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-113884%22%20slang%3D%22en-US%22%3E%3CP%3EJan%2C%20it%20looks%20like%20here%20clipboard%20is%20not%20locked%20by%20any%20other%20program.%20Even%20if%20external%20clipboard%20doesn't%20work%20Excel%20shall%20copy%2Fpaste%20within%20it%2C%20you%20only%20not%20able%20to%20copy%2Fpaste%20from%20Excel%20outside.%20Something%20is%20wrong%20within%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20above%20is%20only%20my%20guess%2C%20i%20could%20be%20wrong.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-113861%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-113861%22%20slang%3D%22en-US%22%3EWhat%20about%20the%20suggestion%20to%20turn%20off%20clipboard%20sharing%20in%20VNC%20viewer%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Foffice%2Fforum%2Foffice_2016-excel%2Fclipboard-problem-in-excel-2016%2F224b2a59-8a0c-4897-baba-a481dd06e085%3Fauth%3D1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Foffice%2Fforum%2Foffice_2016-excel%2Fclipboard-problem-in-excel-2016%2F224b2a59-8a0c-4897-baba-a481dd06e085%3Fauth%3D1%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-113637%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-113637%22%20slang%3D%22en-US%22%3EAh%20ok%2C%20that's%20not%20the%20issue%20then.%20Really%20strange%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-113611%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-113611%22%20slang%3D%22en-US%22%3E%3CP%3EMine%20looks%20basically%20identical%20to%20yours.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-113605%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-113605%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Jon%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnder%20the%20Home%20Ribbon%2C%20can%20you%20expand%20cell%20styles.%26nbsp%3B%20%26nbsp%3BDo%20you%20have%20something%20like%20this%3F%26nbsp%3B%20or%20are%20there%20many%20many%20odd%20formats..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20583px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F21616i8CEA4F77A00E551B%2Fimage-dimensions%2F583x425%3Fv%3D1.0%22%20width%3D%22583%22%20height%3D%22425%22%20alt%3D%22Cell%20Styles.PNG%22%20title%3D%22Cell%20Styles.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-113604%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-113604%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Jon%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnder%20the%20Home%20Ribbon%2C%20can%20you%20expand%20cell%20styles.%26nbsp%3B%20%26nbsp%3BDo%20you%20have%20something%20like%20this..%26nbsp%3B%20or%20are%20there%20many%20many%20odd%20formats..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20824px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F21616i8CEA4F77A00E551B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Cell%20Styles.PNG%22%20title%3D%22Cell%20Styles.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-113532%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-113532%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%2C%20I'm%20using%20a%20PC.%26nbsp%3B%20I've%20tried%20Office%20repair%2Fupdate%20and%20that%20hasn't%20solved%20the%20problem.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-113525%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-113525%22%20slang%3D%22en-US%22%3E%3CP%3EJon%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20least%20clear%20what%20happens%20with%20dashed%20border%20-%20if%20clipboard%20doesn't%20work%20it%20dissappears.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGoogle%20says%20similar%20issue%20appears%20from%20time%20to%20time%2C%20for%20example%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304933-excel-for-mac%2Fsuggestions%2F17693512-after-upgrade-to-office-365-cut-and-paste-does%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304933-excel-for-mac%2Fsuggestions%2F17693512-after-upgrade-to-office-365-cut-and-paste-does%3C%2FA%3E%20(by%20the%20way%2C%20you%20are%20on%20Mac%20or%20on%20PC%3F)%20or%20here%20%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Foffice%2Fforum%2Foffice_2016-excel%2Fclipboard-problem-in-excel-2016%2F224b2a59-8a0c-4897-baba-a481dd06e085%3Fauth%3D1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Foffice%2Fforum%2Foffice_2016-excel%2Fclipboard-problem-in-excel-2016%2F224b2a59-8a0c-4897-baba-a481dd06e085%3Fauth%3D1%3C%2FA%3E.%3C%2FP%3E%3CP%3EBut%20i%20didn't%20find%20concrete%20solution%2C%20sorry.%20I'd%20start%20from%20Office%20repair%2Fupdate%20if%20that%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-113437%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-113437%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sergei%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENo%2C%20it%20shows%20an%20open%20parentheses%20in%20the%20clipboard%2C%20not%20the%20contents%20of%20the%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-113411%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-113411%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Jon%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20open%20clipboard%20(as%20on%20picture)%20do%20you%20see%20what%20you%20copied%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20350px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F21578i9CDADAD15A6AB2EC%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Clipboard.JPG%22%20title%3D%22Clipboard.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-113398%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-113398%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20suggestion%2C%20I%20didn't%20even%20know%20safe%20mode%20was%20an%20option%20for%20Excel.%26nbsp%3B%20Unfortunately%20it%20looks%20like%20that%20isn't%20the%20issue.%26nbsp%3B%20I%20tried%20starting%20in%20safe%20mode%20and%20the%20same%20problem%20exists.%26nbsp%3B%20Any%20other%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-113237%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-113237%22%20slang%3D%22en-US%22%3ETry%20starting%20Excel%20in%20safe%20mode%20(press%20the%20control%20key%20immediately%20after%20starting%20Excel%2C%20it%20should%20pop%20up%20a%20confirmation%20dialog%20to%20ask%20whether%20you%20want%20to%20start%20in%20safe%20mode).%3CBR%20%2F%3EIf%20that%20makes%20your%20problem%20go%20away%2C%20the%20cause%20is%20very%20likely%20either%20an%20add-in%20or%20your%20personal%20macro%20workbook.%20See%3A%20%3CA%20href%3D%22http%3A%2F%2Fjkp-ads.com%2Farticles%2Fstartupproblems.asp%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fjkp-ads.com%2Farticles%2Fstartupproblems.asp%3C%2FA%3E%20with%20some%20pointers%20as%20to%20how%20to%20trouble-shoot%20add-ins.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-651179%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-651179%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F84567%22%20target%3D%22_blank%22%3E%40Jon%20Firooz%3C%2FA%3E%26nbsp%3B%20Hi%2C%20same%20issue%20i%20faced%20for%20dashed%20lines%20being%20disappearing.%20but%20its%20kind%20of%20solved%2C%20when%20i%20understand%20that%20it%20was%20happening%20due%20to%20a%20remote%20app%20%22%20Teamviewer%22%20being%20used%20at%20the%20same%20time.%20As%20when%20i%20closed%20the%20teamviewer%20app%2C%20excel%20started%20behaving%20normally.%20I%20hope%20this%20could%20help%20for%20any%20one%20facing%20same%20issue%20within%20similar%20circumstances.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-752564%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752564%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20had%20the%20same%20problem%20with%20Excel%2C%20and%20now%20a%20similar%20problem%20with%20Word%2C%20pasting%20content%20from%20one%20table%20to%20another.%20The%20company%20uses%20365%20on%20PCs.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20take%20problematic%20documents%20home%20with%20me%20to%20test%20with%20an%20older%20version%20of%20Office%2C%20on%20a%20different%20OS%20(Mac).%209%20times%20out%20of%26nbsp%3B%2010%2C%20it%20works%2C%20and%20converts%20back%20without%20issues.%20That's%20what%20I'll%20do%20in%20this%20case.%20I'll%20update%20accordingly%20if%20it%20works.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOtherwise%2C%20if%20you%20can%20get%20this%20to%20function%20with%20your%20current%20configuration%2C%20I%20recommend%20saving%20a%20copy%20of%20your%20work%20on%20a%20USB%20stick%2C%20and%20storing%20it%20in%20a%20Grand%20Cayman%20bank%20vault.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-803069%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803069%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F84567%22%20target%3D%22_blank%22%3E%40Jon%20Firooz%3C%2FA%3E%26nbsp%3BFWIW%2C%20I%20had%20a%20similar%20problem.%20I%20was%20unable%20to%20copy%20or%20cut%20(nothing%20appeared%20in%20the%20Clipboard).%20I%20discovered%20that%20I%20had%20opened%20another%20Excel%20file%20in%20Protected%20View.%20When%20I%20allowed%20editing%20for%20the%20protected%20file%2C%20I%20recovered%20the%20ability%20to%20copy%20and%20cut%20in%20the%20original%20file.%3C%2FP%3E%3CP%3EI'm%20running%20Microsoft%20Office%20Business%2C%20Version%201907%20(Build%2011901.20176%20Click-to-Run).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-839770%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-839770%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130375i08D01EB0386FC9FA%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EJust%20trying%20to%20copy%20a%20blank%20cell%20I%20get%20this.%26nbsp%3B%20It%20is%20maddening.%26nbsp%3B%20My%20clip%20board%20has%20nothing%20in%20it%2C%20except%20the%20bit%20of%20screen%20shot%20to%20show%20you%20the%20Clipboard%20Item%20not%20collected.%20I've%20rebooted.%3C%2FP%3E%3CP%3ESent%20the%20file%20to%20a%20co-worker%20and%20they%20can%20cut%20and%20paste.%26nbsp%3B%20This%20is%20office%20Microsoft%20Office%20Professional%20Plus%202016.%26nbsp%3B%20The%20document%20was%20created%20by%20me%20and%20is%20not%20protected.%26nbsp%3B%20Safe%20mode%20does%20not%20help.%20I%20would%20like%20to%20submit%20a%20frown%20but%20in%20file%20I%20have%20no%20feedback%20option.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-839867%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-839867%22%20slang%3D%22en-US%22%3EDo%20none%20of%20the%20copy%20methods%20work%3F%20Right%20click%20copy%2C%20Ctrl%20C%3CBR%20%2F%3E%3CBR%20%2F%3EFeedback%20might%20be%20under%20File%20(then%20down%20the%20bottom%20left%20corner)%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-839876%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-839876%22%20slang%3D%22en-US%22%3ECorrect%2C%20none%20of%20the%20methods%20work%20ctrl-c%20or%20right%20click%2C%20select%20copy.%20I%20can%20paste%20into%20excel%2C%20I%20just%20cannot%20pull%20anything%20out.%20Other%20apps%20are%20having%20no%20trouble.%20What%20might%20be%20different%20is%20I%20run%20a%20few%20powershell%20scripts%20that%20create%20excel%20files%20with%20out%20the%20application.%20I%20had%20to%20add%20a%20couple%20directories%20to%20my%20machine%20for%20this%20to%20work.%20I%20copy%20these%20excel%20files%20to%20a%20folder%20that%20is%20linked%20to%20a%20teams%20folder%20so%20that%20others%20can%20see%20the%20data.%20I've%20been%20doing%20this%20for%20a%20couple%20years%2C%20the%20cut%20an%20paste%20thing%20just%20started.%20Unless%20my%20task%20bar%20is%20blocking%20it%20on%20the%20left%20when%20I%20hit%20file%20I%20have%20the%20following.%20Info%20New%20Open%20Save%20Save%20As%20Print%20Share%20Export%20Close%20Account%20Options%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1085917%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1085917%22%20slang%3D%22en-US%22%3ESee%20more%20at%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Ftroubleshoot%2Fexcel%2Fcannot-paste-attributes%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Ftroubleshoot%2Fexcel%2Fcannot-paste-attributes%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1086434%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1086434%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F504233%22%20target%3D%22_blank%22%3E%40jrizor%3C%2FA%3E%26nbsp%3BThat%20does%20not%20help%20me.%26nbsp%3B%20When%20I%20open%20Excel%20I%20get%20an%20error%20that%20says%20Cannot%20use%20object%20linking%20and%20embedding.%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Not%20cut%20and%20paste%20will%20work%20in%20Excel%20for%20me%20period%20works%20fine%20in%20all%20other%20apps.%26nbsp%3B%20I%20had%20to%20create%20a%20couple%20new%20directories%20in%20order%20to%20use%20Excel%20programmatically.%26nbsp%3B%20Maybe%20Microsoft%20does%20not%20want%20you%20to%20do%20both%20use%20excel%20with%20out%20the%20app%20and%20have%20the%20ability%20to%20cut%20and%20paste.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1161046%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1161046%22%20slang%3D%22en-US%22%3E%3CP%3EA%20POSSIBLE%20FIX%20FOR%20YOU%3C%2FP%3E%3CP%3EHi%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F504233%22%20target%3D%22_blank%22%3E%40jrizor%3C%2FA%3E%26nbsp%3B%20refer%20to%20this%20link%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.drivereasy.com%2Fknowledge%2Fsolved-copy-and-paste-not-working%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.drivereasy.com%2Fknowledge%2Fsolved-copy-and-paste-not-working%2F%3C%2FA%3E%26nbsp%3B%20STEP%203%20worked%20for%20me%20%26amp%3B%20several%20others%20on%20that%20site.%3C%2FP%3E%3CP%3EHope%20this%20helps%20%3CLI-EMOJI%20id%3D%22lia_winking-face%22%20title%3D%22%3Awinking_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1350929%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1350929%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F84567%22%20target%3D%22_blank%22%3E%40Jon%20Firooz%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20having%20the%20same%20problem%20sporadically.%20For%20me%2C%20the%20problem%20is%20when%20I%20try%20to%20copy%20text%20in%20MSWord%2C%20and%20paste%20it%20to%20EXCEL%2C%20or%20vice%20versa.%20But%20I%20think%20it's%20the%20same%20underlying%20problem.%20For%20some%20reason%2C%20EXCEL%20hangs%20onto%20what%20ever%20was%20previously%20in%20the%20clipboard%2C%20instead%20of%20updating%20it%20with%20the%20new%20stuff%20you've%20copied.%20For%20you%2C%20it%20was%20a%20bracket%20in%20the%20previous%20clipboard.%20I%20found%20a%20solution%20that%20worked%20for%20me%2C%20on%20another%20site.%20See%20if%20this%20works%20for%20you%2C%20or%20anyone%20else%20with%20this%20issue%3A%3C%2FP%3E%3CP%3Ein%20EXCEL%2C%20under%20the%20%22file%22%20tab%2C%20go%20into%20%22options%22%2C%20and%20then%20%22general%22%2C%20and%20UNCLICK%20THE%20BOX%20%22enable%20live%20preview%22.%20It%20worked%20for%20me%2C%20and%20it's%20a%20pretty%20innocuous%20change%20to%20try.%3C%2FP%3E%3CP%3EGreg%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1473247%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1473247%22%20slang%3D%22en-US%22%3E%3CP%3EPress%20Crtl%20%2B%20C%20twice.%20It%20will%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1473256%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1473256%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F84567%22%20target%3D%22_blank%22%3E%40Jon%20Firooz%3C%2FA%3E%26nbsp%3BPress%20Ctrl%20%2B%20C%20twice%20quickly%20it%20will%20work%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1536876%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1536876%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F115532%22%20target%3D%22_blank%22%3E%40Marie%20Dawson%3C%2FA%3EYour%20solution%20to%20the%20Excel%20Copy%20issue%20worked%20on%20my%20Windows%207%20Office%202010%20Pro!%20But%20the%20instructions%20you%20stated%20was%20not%20quite%20right%20on%20this%20PC.%20You%20said%20that%20you%20changed%20the%20selection%20in%20Options%2FFormula%2FWorkbook%20Calculations%20from%20'Manual'%20to%20'Automatic'.%20But%20my%202010%20Excel%20already%20had%20'Automatic'%20selected.%20There%20is%20a%20third%20selection%20here%2C%20and%20that%20is%20'Automatic%20except%20for%20data%20tables'.%20I%20set%20it%20to%20that%2C%20and%20the%20Copy%20function%20now%20works!%20And%20by%20'it%20works'%2C%20I%20specifically%20mean%20that%20if%20you%20do%20a%20right%20click%20on%20any%20cell%20or%20selection%20of%20cells%2C%20and%20then%20select%20Copy%2C%20the%20dashes%20around%20the%20selection%20would%20go%20away%20with%20in%201-2%20seconds%2C%20and%20the%20Copy%20would%20only%20be%20good%20when%20pasting%20pure%20data.%20And%20on%20one%20of%20my%20client's%20computers%26nbsp%3B%20(running%20Windows%2010%20and%20Office%20365%20(Office%202016))%2C%20the%20Copy%20would%20not%20work%20at%20all%20-%20no%20data%20was%20copied%20or%20storable%2C%20and%20the%20dashes%20went%20away%20right%20away%20on%20the%20highlighted%20cells%20as%20well.%20The%20Copy%20and%20the%20Paste%20Special%20always%20worked%20when%20you%20used%20the%20Ctrl%20C%20method%20twice%20in%20a%20row%2C%20and%20this%20was%20before%20changing%20any%20of%20the%20Option%20settings.%20I%20will%20post%20again%20after%20I%20try%20this%20solution%20on%20my%202%20clients%20that%20are%20having%20this%20problem%20now%20with%20Office%202016%20on%20Windows%2010.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVincent%20(07-21-2020)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1551747%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1551747%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F735399%22%20target%3D%22_blank%22%3E%40VLavalleAZ%3C%2FA%3E%26nbsp%3B%20I%20tried%20this...%20unfortunately%20doesn't%20work%20for%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20CTRL-C%20from%20Excel%20365%20it%20will%20CTRL-V%20to%20itself%20and%20to%20all%20these%20programs%20OK%3A%20MS%20Word%20365%3B%20MS%20Word%202007%3B%20notepad.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20it%20will%20not%20paste%20any%20data%20to%20Excel%202007.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20CTRL-V%20to%20Excel%202007%20it%20highlights%20the%20correct%20area%20of%20rows%20and%20columns%2C%20and%20overwrites%20all%20the%20cells%20with%20blanks.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1564937%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564937%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20-%20I%20have%20the%20same%20issue%20mentioned%20above.%3C%2FP%3E%3CP%3EIf%20i%20Control%20%2B%20C%20I%20see%20that%20the%20clipboard%20shows%20the%20data%2C%20so%20it%20is%20working.%3C%2FP%3E%3CP%3EIf%20i%20Control%20%2B%20V%20then%20the%20information%20is%20not%20pasted%20into%20the%20new%20excel%20sheet.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20use%20the%20clipboard%20I%20can%20paste%20the%20information%20but%20not%20with%20the%20format%20of%20the%20initial%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestion%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1565104%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1565104%22%20slang%3D%22en-US%22%3E%3CP%3EBefore%20you%20do%20the%20%22Paste%22%20command%2C%20you%20should%20make%20sure%20that%20you%20only%20have%20one%20spreadsheet%20selected%20in%20your%20workbook.%20that%20did%20the%20trick%20for%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%20J%3C%2FP%3E%3CP%3Eesper%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F748903%22%20target%3D%22_blank%22%3E%40FMiriani%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1565117%22%20slang%3D%22de-DE%22%3ESubject%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1565117%22%20slang%3D%22de-DE%22%3Emaybe%20delete%20the%20clipboard%20and%20try%20again%20...%20is%20just%20a%20suggestion%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Delete%20clipboard%20by%20command%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Press%20the%20key%20combination%20%5BWindows%5D%20%2B%20%5BR%5D.%20%3CBR%20%2F%3E%20A%20small%20window%20now%20opens.%20Enter%20the%20following%20command%20there%3A%20cmd%20%2F%20c%20%22echo%20off%20%7C%20clip%22.%20Click%20%22OK%22%20to%20confirm.%20The%20clipboard%20is%20then%20automatically%20emptied.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Best%20regards%2C%20%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1584250%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1584250%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20what%20broke%20my%26nbsp%3Bcut-and-paste%20abiltiy%20in%20Excel.%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F84567%22%20target%3D%22_blank%22%3E%40Jon%20Firooz%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20produce%20some%20spreadsheets%20programmatically%20with%20powershell%20in%20a%20scheduled%20task.%3C%2FP%3E%3CP%3EThis%20only%20works%20if%20you%20add%20these%20directories%20to%20your%20machine%3C%2FP%3E%3CPRE%3E%3CSPAN%20class%3D%22pln%22%3EC%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%3A%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3E%5CWindows%5CSystem32%5Cconfig%5Csystemprofile%5CDesktop%20%20%3C%2FSPAN%3E%3C%2FPRE%3E%3CPRE%3E%3CSPAN%20class%3D%22pln%22%3EC%3C%2FSPAN%3E%3CSPAN%20class%3D%22pun%22%3E%3A%3C%2FSPAN%3E%3CSPAN%20class%3D%22pln%22%3E%5CWindows%5CSysWOW64%5Cconfig%5Csystemprofile%5CDesktop%3C%2FSPAN%3E%3C%2FPRE%3E%3CP%3EThat%20solution%20comes%20from%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsuperuser.com%2Fquestions%2F579900%2Fwhy-cant-excel-open-a-file-when-run-from-task-scheduler%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsuperuser.com%2Fquestions%2F579900%2Fwhy-cant-excel-open-a-file-when-run-from-task-scheduler%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20you%20add%20those%20directories%20your%20cut%20and%20paste%20in%20excel%20will%20stop%20working.%26nbsp%3B%20It%20is%20real%20time%2C%20you%20do%20not%20even%20need%20to%20open%2Fclose%20excel.%26nbsp%3B%20Open%20a%20spreadsheet%20add%20those%20directories%20cut%20and%20paste%20in%20excel%20will%20stop%20working.%26nbsp%3B%20Remove%20those%20directories%20it%20will%20start%20working%20again.%26nbsp%3B%20The%20issue%20is%20that%20MS%20does%20not%20test%20their%20stuff%20to%20be%20run%20in%20an%20automated%20way%2C%20everything%20is%20based%20on%20user%20interaction%2C%20another%20link%20within%20the%20page%20above.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F257757%2Fconsiderations-for-server-side-automation-of-office%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F257757%2Fconsiderations-for-server-side-automation-of-office%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EAll%20current%20versions%20of%20Microsoft%20Office%20were%20designed%2C%20tested%2C%20and%20configured%20to%20run%20as%20end-user%20products%20on%20a%20client%20workstation.%20They%20assume%20an%20interactive%20desktop%20and%20user%20profile.%20They%20do%20not%20provide%20the%20level%20of%20reentrancy%20or%20security%20that%20is%20necessary%20to%20meet%20the%20needs%20of%20server-side%20components%20that%20are%20designed%20to%20run%20unattended.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1835776%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1835776%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F169860%22%20target%3D%22_blank%22%3E%40JOHN%20EICHMANN%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOMGoodness%20sir%2C%20you%20have%20fixed%20my%20problem%20that%20has%20plagued%20me%20for%20months!%26nbsp%3B%20I%20dont%20know%20why%20this%20worked%20when%20nothing%20else%20would%2C%20but%20by%20jove%20you%20have%20done%20it%20sir!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETHANK%20YOU!!!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1888738%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%2Fpaste%20no%20longer%20working%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1888738%22%20slang%3D%22en-US%22%3EI%20don%E2%80%99t%20know%20why%20but%20you%20can%20resolve%20the%20issue%20by%20copy%20pasting%20(or%20drag%20to%20paste%20if%20it%20is%20multiple%20cells)%20then%20after%20you%20paste%20press%20save%20again%20and%20it%20will%20calculate%20base%20on%20the%20formula.%20The%20save%20option%20after%20pasting%20is%20what%20will%20resolve%20your%20problem.%20I%20hope%20this%20helps.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Sometime in the last few months the copy/paste function within Excel (Office 365 version) stopped working for me.  I have updated Windows and all Office apps to the latest version but that hasn't fixed the problem.  I've also run the Office 365 

 

The symptom is very strange.  When I hit Ctrl-C (or use the drop-down menus) on a cell in Excel the dashed lines that surround a cell selected for copying show up very briefly but immediately disappear.  If I go to another cell and paste it just puts a open parenthesis "(" in the cell.  Using Ctrl-X to cut exhibits similar behavior.

 

If I repeatedly hit Ctrl-C it will occasionally work (the dashed lines remain and I can paste) but it typically takes 15-20 tries before it will work and if I try again it will fail.  This only seems to affect me when I try to copy cells.  If I select a cell and then edit the cell and manually select the content of the cell I can copy and paste with no issue.  It also appears to only be an issue when a cell is not empty.  If I select an empty cell I can copy/paste just fine.  If I select a cell that has been highlighted but has no content that also works properly.  It's only when there's text or a formula in the cell that this is an issue.

 

This only affects Excel, I haven't observed the issue in any other app.

 

Any ideas?

88 Replies
Highlighted
Try starting Excel in safe mode (press the control key immediately after starting Excel, it should pop up a confirmation dialog to ask whether you want to start in safe mode).
If that makes your problem go away, the cause is very likely either an add-in or your personal macro workbook. See: http://jkp-ads.com/articles/startupproblems.asp with some pointers as to how to trouble-shoot add-ins.
Highlighted

Thanks for the suggestion, I didn't even know safe mode was an option for Excel.  Unfortunately it looks like that isn't the issue.  I tried starting in safe mode and the same problem exists.  Any other ideas?

Highlighted

Hi Jon,

 

If you open clipboard (as on picture) do you see what you copied?

Clipboard.JPG

 

Highlighted

Hi Sergei,

 

No, it shows an open parentheses in the clipboard, not the contents of the cell.

Highlighted

Jon,

 

At least clear what happens with dashed border - if clipboard doesn't work it dissappears. 

 

Google says similar issue appears from time to time, for example https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/17693512-after-upgrade-to-office... (by the way, you are on Mac or on PC?) or here https://answers.microsoft.com/en-us/office/forum/office_2016-excel/clipboard-problem-in-excel-2016/2....

But i didn't find concrete solution, sorry. I'd start from Office repair/update if that help.

Highlighted

Thanks, I'm using a PC.  I've tried Office repair/update and that hasn't solved the problem.  

Highlighted

Hi Jon,

 

Under the Home Ribbon, can you expand cell styles.   Do you have something like this..  or are there many many odd formats..

 

Cell Styles.PNG

Highlighted

Hi Jon,

 

Under the Home Ribbon, can you expand cell styles.   Do you have something like this?  or are there many many odd formats..

 

Cell Styles.PNG

Highlighted

Mine looks basically identical to yours.

Highlighted
Ah ok, that's not the issue then. Really strange
Highlighted
Highlighted

Jan, it looks like here clipboard is not locked by any other program. Even if external clipboard doesn't work Excel shall copy/paste within it, you only not able to copy/paste from Excel outside. Something is wrong within Excel.

 

However, above is only my guess, i could be wrong.

Highlighted

Correct, I don't think that's the case.  I'm not getting an error that the clipboard is locked and the clipboard still functions correctly.  ex. if I edit a comment I can select text, copy, and paste it inside or outside of excel just like I can select a formula in a cell and copy/paste it.  I just can't copy/paste a cell.

Highlighted
Any chance your keyboard has a problem? e.g. if the Escape key is pressed, the clipboard is emptied in Excel when a cell is copied, but not if you copy the text of a comment.
Highlighted

Sorry for the delayed response, for some reason I didn't get a notification about another post so I just saw it when I came back and checked manually.  

 

It's definitely not a keyboard issue.  I have the same problem at home and at work and regardless of whether I'm using a docking station with external keyboard or built-in laptop keyboard.

 

Any other ideas?  Excel is basically worthless if you can't copy and paste cells.

Highlighted
I had a similar issue, I copied a selection of rows to the clipboard, then tried to paste in a single cell below where I copied from and got the error "You can't paste here because the copy area and paste area aren't the same size. Select just one cell in the paste area or an area that's the same size, and try pasting again."
It turned out that I wasn't scrolled all the way over, so column A wasn't showing and I was trying to paste the selection starting with column B at the row of the currently highlighted cell. I just needed to scroll over horizontally select the cell in column A, and press Enter or Ctrl-V to paste.
Highlighted

I am in the same boat.

 

I can copy/paste from Excel, to Excel.

I am unable to copy/past from OneNote to Excel.

 

This function was working fine a couple of weeks ago, and now it is not. I am also noticing a latency in Excel across all files.

 

 

Highlighted

I am also in the same boat. 

 

Excel in Windows 10 slows down very frequently, even when only 1 workbook with no complex formulas is open.

 

The copy/paste function for cells is intermittent at best, you cannot copy a formula across multiple cells like you could in the past, and another unrelated issue: you can't delete a column or row that is under a merged cell at the beginning of the column or row like you could in the past.

Highlighted

Hi Jon,

 

I have the exact same problem on both my surface pro 4 and on my freshly formatted desktop pc.

In Excel 2016, I cannot copy any cells. The dashed lines will show briefly and then disappears.. A copied cell usually have the dashed lines circling it all the time.

When I try to paste, a left bracket shows up. "  (  "

 

Can anyone help us solve this mysterious problem..?