Not responding through copy and paste

%3CLINGO-SUB%20id%3D%22lingo-sub-1543278%22%20slang%3D%22en-US%22%3ENot%20responding%20through%20copy%20and%20paste%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1543278%22%20slang%3D%22en-US%22%3EHi%20everyone!%20I'm%20hoping%20someone%20can%20help%20me%20%3CSPAN%20class%3D%22lia-unicode-emoji%22%20title%3D%22%3Afolded_hands%3A%22%3E%3Cspan%20class%3D%22lia-unicode-emoji%22%20title%3D%22%3Afolded_hands%3A%22%3E%F0%9F%99%8F%F0%9F%8F%BB%3C%2Fspan%3E.%20%3C%2FSPAN%3E%20I%20have%20a%20excel%20file%20with%20various%20sheets%20I%20use%20for%20caravan%20hire%20and%20managing%20caravans%2C%20there%20are%20various%20formulas%20across%20the%20sheets%20for%20accounting%20purposes.%20I%20read%20that%20too%20much%20copying%20and%20pasting%20can%20be%20the%20cause%20of%20my%20excel%20%22not%20responding%22%20but%20this%20is%20an%20essential%20part%20of%20work%20which%20is%20taking%20forever%20to%20perform%2C%20can%20anyone%20help%20please.%20Thank%20you%20%3Apensive_face%3A%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
Hi everyone! I'm hoping someone can help me 🙏🏻. I have a excel file with various sheets I use for caravan hire and managing caravans, there are various formulas across the sheets for accounting purposes. I read that too much copying and pasting can be the cause of my excel "not responding" but this is an essential part of work which is taking forever to perform, can anyone help please. Thank you :pensive_face:
3 Replies
Highlighted

Hello @Alicia779

 

Do you also use macros for your Excel sheet? If yes, an option to clear would be this: http://www.vbaexpress.com/kb/getarticle.php?kb_id=205 or you record a macro with the steps from here: https://www.solveyourtech.com/how-to-clear-the-clipboard-in-excel/ and run it in-between. 

I hope that helps

Cheers
Rolf
#MCT #LearnWithRolf #TheCloud42

Highlighted

Hello @Alicia779

 

I am not quite sure what your inquiry is, are you having issues with copy-pasting in Excel and the program going to "not responding" and crashing, or is Excel just slow and still performing the work?

 

If you are working within a big file with many formulas, there is a number of things that you can do to increase the file performance and stability. The most harsh form of solution usually is to copy everything over into a new file, as sometimes the files themselves break when they crash too often. Generally, best practice includes removing the number of formulas, or reducing the amount of data in the file.

 

So as a possible solution for you: if you work with financial data, split off historic data belonging to closed periods. For instance, if you have a file with all the data of the past ten years, you will probably not need the data that is 2+ years old. Retire your current file and start a new one, copy over all the data of the past two years and start a new with the file. You can do that once every year if you want and thus keep all data archived safely and still keep the files working well.

 

Typically, Excel files lose performance through both the amount of data and formulas, and the issues increase exponentially, since with every extra line of data, one line's worth of formulas get added.

 

If that solves your issues please let us know. Otherwise perhaps try to give us a better explanation of your issue.  

Highlighted
Hi, yes, the issue is not responding when I'm trying to copy and paste and its starting to take so long that I close the program. I read that the issue could be the macros and there's instructions to copy the sheets onto a new file which I'm happy to do every time if it means I can get my work done in half the time. I only have one seasons worth of bookings on one workbook so there isn't years of work on there. I'll let you know how I get on with that action. Thank you