There must be a better way Not every sheet has all of the locations listed on the dashboard. Excel freezes and this process took me days last month. I then copy and paste (to move) the pink shaded cells at the bottom of each worksheet. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. (I did not delete the hidden months in the blue tab.
#Why does excel keep freezing when i copy and paste code
NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment.
Other copy / paste in notepad is just fine - and copy FROM Excel TO Notepad is just fine too.
If I try to paste anywhere else, the application freezes. If you can just narrow it down a bit, you will know where to focus. Trying these will tell you where the issue lies. Then close and reopen Excel and with just the new file open, try copying and pasting. I can open a brand new worksheet, type in 'abc' and copy the cell. Alternatively, copy all your data to a brand new file with a single tab and paste as 'values only'. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block Good day, User has repeatable issue - pasting into Excel freezes excel for around 15 seconds. Fortunately, Microsoft provides a dedicated Paste Special option that’ll help you use different types of paste options for special cases. This will award the user a ClippyPoint and change the post's flair to solved. If you’re trying to paste special graphics from one Excel sheet to the other, you won’t be able to do it using the traditional Paste option. OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem.