SOLVED

New laptop has macros running like a slow sweeping demo mode?

%3CLINGO-SUB%20id%3D%22lingo-sub-1546455%22%20slang%3D%22en-US%22%3ENew%20laptop%20has%20macros%20running%20like%20a%20slow%20sweeping%20demo%20mode%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546455%22%20slang%3D%22en-US%22%3E%3CP%3EI%20don't%20know%20if%20anyone%20could%20help%20with%20a%20simple%20tip%20with%20this%20issue%3F%3C%2FP%3E%3CP%3EI%20had%20no%20problem%20with%20an%20intel%20i3%204gb%20laptop%20swiftly%20running%20through%20my%20macros.%20I%20have%20now%20purchased%20an%20intel%20i5%208gb%20laptop%20that%20is%20very%20swift%20at%20everything%20except%20it%20runs%20the%20macro%20(like%20in%20slow%20motion)%20showing%20all%20the%20calculations%2C%20copies%2C%20pastes%20and%20scrolls%20etc.%20I%20am%20hoping%20there%20is%20an%20easy%20fix%20for%20this.%20The%20new%20laptop%20is%20much%20quicker%20at%20all%20other%20tasks%20except%20this%3F%26nbsp%3B%20%26nbsp%3BKind%20regards%20Dave%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1546455%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1546546%22%20slang%3D%22de-DE%22%3ERe%3A%20New%20laptop%20has%20macros%20running%20like%20a%20slow%20sweeping%20demo%20mode%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546546%22%20slang%3D%22de-DE%22%3ESometimes%20the%20%23referencing%20entries%20are%20in%20the%20columns%20%2F%20rows.%20So%20a%20reference%20formulas%20in%20these%20columns%20castrates%20the%20pc.%20But%20you%20can't%20understand%20any%20longer%20what%20actually%20happens%20in%20these%20columns%20%2F%20rows%20and%20macros%20if%20you%20can't%20run%20the%20sheet%20yourself.%20Since%20there%20are%20no%20other%20speed%20problems%20with%20you%2C%20the%20formulas%20in%20the%20spreadsheet%20would%20be%20my%20next%20starting%20point%20to%20localize%20the%20problem.%20%3CBR%20%2F%3E%20But%20as%20I%20said%2C%20it's%20just%20a%20guess%20that%20I'm%20making%20here.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20I%20would%20be%20happy%20to%20find%20out%20if%20I%20could%20help.%20%3CBR%20%2F%3E%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-1547377%22%20slang%3D%22en-US%22%3ERe%3A%20New%20laptop%20has%20macros%20running%20like%20a%20slow%20sweeping%20demo%20mode%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1547377%22%20slang%3D%22en-US%22%3ELightening%20fast%20this%20morning%2C%20haven't%20a%20clue%20what%20the%20laptop%20fairies%20have%20done%20overnight%20but%20all%20good%20now.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1547389%22%20slang%3D%22de-DE%22%3ERe%3A%20New%20laptop%20has%20macros%20running%20like%20a%20slow%20sweeping%20demo%20mode%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1547389%22%20slang%3D%22de-DE%22%3EThen%20the%20clipboard%20in%20Excel%20was%20most%20likely%20full.%20%3CBR%20%2F%3E%20here%20is%20a%20link%20to%20delete.%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fclear-the-clipboard-7afbf55f-d7d5-4096-87a0-eb17f821d321%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fclear-the-clipboard-7afbf55f-d7d5-4096-87a0-eb17f821d321%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20Or%20delete%20with%20cmd%20%3CBR%20%2F%3E%20cmd%20%2F%20c%20%22echo%20off%20%7C%20clip%22%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1548809%22%20slang%3D%22en-US%22%3ERe%3A%20New%20laptop%20has%20macros%20running%20like%20a%20slow%20sweeping%20demo%20mode%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1548809%22%20slang%3D%22en-US%22%3EThanks%20for%20your%20help%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1549354%22%20slang%3D%22de-DE%22%3ERe%3A%20New%20laptop%20has%20macros%20running%20like%20a%20slow%20sweeping%20demo%20mode%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1549354%22%20slang%3D%22de-DE%22%3EYou're%20welcome%2C%20thanks%20for%20the%20feedback.%20If%20it%20helped%2C%20please%20mark%20the%20answer%20as%20correct%2C%20so%20others%20can%20also%20find%20out%20more.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
Contributor

I don't know if anyone could help with a simple tip with this issue?

I had no problem with an intel i3 4gb laptop swiftly running through my macros. I have now purchased an intel i5 8gb laptop that is very swift at everything except it runs the macro (like in slow motion) showing all the calculations, copies, pastes and scrolls etc. I am hoping there is an easy fix for this. The new laptop is much quicker at all other tasks except this?   Kind regards Dave

5 Replies
Sometimes the #referencing entries are in the columns / rows. Also a reference formulas in these columns castrates the pc. But you can no longer understand what actually happens in these columns / rows and macros if you can not run the sheet yourself. Since there are no other speed problems with you, the formulas in the spreadsheet would be my next starting point to localize the problem.
But as I said, it's just a guess that I'm making here.

I would be happy to find out if I could help.

Nikolino
I know I don't know anything (Socrates)
Lightening fast this morning, haven't a clue what the laptop fairies have done overnight but all good now.
Best Response confirmed by harwood66 (Contributor)
Solution
Then the clipboard in Excel was most likely full.
here is a link to delete.
https://support.microsoft.com/en-gb/office/clear-the-clipboard-7afbf55f-d7d5-4096-87a0-eb17f821d321?...

Or delete with cmd
cmd / c "echo off | clip"

Nikolino

I know I don't know anything (Socrates)
Thanks for your help
You're welcome, thanks for the feedback. If it helped, please mark the answer as correct, so others can also find out more.

Nikolino
I know I don't know anything (Socrates)