@dkmentions
Thanks for the details. Unfortunately, I have no trouble cutting and pasting the entire ZONDA section. So whatever is wrong, it's not the spreadsheet per se.
Just so you know, for future reference, I used to teach scientists and others how to do diagnostic thinking, for the purpose of trying to identify the cause of an unexplained deviation from expected results. The process begins with a set of what we'd call Diagnostic Questions. That set of questions that I first sent you was a representative sample--tailored to your presenting problem--to get a more complete picture of the nature of the problem, where and when it occurred, the extent or magnitude of it They were not just idle curiosity.
A simple statement such as yours at the beginning (when i copy and paste the sheet will stop responding) could be compared to going into a doctor and saying "I have a pain in my left arm," and expecting the doctor to treat you with no more data. A doctor could, indeed, give you the aspirin that worked with the last patient, let's say. But the doctor would be risking malpractice...pain in the left arm can be caused by all kinds of things, from a bruise up to and including heart attack. That's why doctors ask more -- guess what -- diagnostic questions AND do some physical exams and even lab tests once they've started to narrow down the possible causes.
I'd like to be able to help more, but I'm just a private individual--not a Microsoft employee--responding to questions like yours sort of as a hobby in my retirement. Don't have the ability of a full IT professional to log into your computer (as you asked about) and get more hands-on experience, or more diagnostic data.
A question I didn't ask, but will now: do you also use other Microsoft programs (Word, Power Point). Does cut & paste work well with them when they're large files? The fact that you've had similar but less extensive problems with another spreadsheet does suggest to me---this is just a hypothesis, not a complete diagnosis--that your computer may have limited processing capacity in some way.
I can't send the file back. I'll delete it from my computer. You may want to wait and see if anybody else here--any of the other volunteers--has any ideas. Or you can just edit your post and delete the sample sheet. That's all up to you.
