Computer not wakening from sleep

I have posted this issue before: Sometime when wakening my computer from Sleep, it awakens, but the screen does not appear. I have to do a remote login from another machine to get the screen working again. I have gotten some suggestions, but nothing useful.

One more bit of data – and maybe it matters. It seems that every time this happens, it occurs after a session during which I ran some Excel VBA code. I don’t believe that there is anything odd about the code, but some of the files operated on can be very larges (i.e., hundreds of thousands of rows). Even though Excel is not running when the computer goes to sleep, is it possible that some process is still running? Any suggestions for resolving this issue?

my HP computers (HP 8300/800 G3) had similar sleep problem before. now the problem is gone/solved. possible solutions are:

1. BIOS. manufacturer knows its products better but HP wouldn't tell what it did in latest BIOS release. hence I had to follow its BIOS update.
2. ME driver. I was thinking the sleep problem was ME-related. upgrade ME driver.
3. Graphics driver. in my practice, same graphics card, performance varies on different monitors. indeed, on old VGA CRT monitor more stable. I couldn't explain that. Just tell what I see. these are old hardware anyway. For new graphics card, it's designed with new technology. it performs better on new LCD/LED monitors.

above I don't know exactly which one fixed my HP's sleep problem but the problem is gone on my Windows 7 after about 1-2 yrs driver upgrade by constant tries.

meanwhile, I did another test, running Windows 11 to see if the problem continues. True, no computer under Windows 11 has sleep problem. Well, Windows 11 really sucks. not a good computer OS (maybe a good mobile device OS, a touch-screen guy loves).

Think I may have figured this out. The awakening slowness seems to have happened after I used an Excel spreadsheet for which I had written some macros. Some of the files operated on were large, read as 'several sheets with 500,000 lines' and the code that caused the issue (sorry - didn't keep it so cannot give the exact problem) was manipulating the sheets directly. Sometime, this required a huge amount of time, such as 5+ minutes to finish and I suspect that the awakening slowness only happened after using this macro.

I recently updated the macro to manage everything in arrays, then write the sheet. The code now executes in a few seconds and I have not had the issue of awakening slowness since updating the code.