Forum Discussion
Copying entire Column then inserting copied cells (column) takes 10-15 minutes to complete???
Hello. I have a spreadsheet with a column or two that I need to shuffle around. This column is largely empty from a data perspective. It does have a number of formulas and conditional formatting in p...
It sounds to me like the basic design--into which this whole procedure has been fitted--is what might need to be reexamined.
So before posting the actual workbook--that image doesn't really tell us much--why don't you describe the business context here? To the extent that you can do this without violating confidentiality or proprietary details, describe what the spreadsheet is all about in the first place. Such things as:
- What kind of data are you working with?
- What are the inputs?
- What are the outputs?
- What sort of processing of inputs is needed in order to produce the output?
- (Presumably this is where that column manipulation fits.)
- I appreciate you reaching out on this but it looks like the downloading of a recent WIN update cured the issue, at least for now. There had been a WIN update sitting in wait to install but my system never notified me as it usually does. This does make sense for my experience with more recent versions of Windows. Without fail, when I notice my system is really underperforming an update to be installed is the culprit. This was both no different and also different. Different because the update wouldn't install. It failed to install in 4 consecutive attempts. I called Windows support directly and after additional unsuccessful attempts at making this update I was sent to Level 2. They had methods to force the update to install. What they did worked but left out one additional .net update which I installed without issue. After reboot completed I booted Excel and the suspect workbook and it performed normally. And, that is my tale!
Again, thanks very much for reaching out!
Douglas
