Excel Glitch

This is another computer issue post. I know that there have not been any posts recently, and I apologize that a computer issue does not lend itself to pretty pictures.

After finally shifting to Office 365 (not a fan of the subscription model), we found that Excel was running horribly. Any attempt to scroll stuttered horribly, and forcing it by dragging the scroll bars caused it to load in after the move. It did not seem to be the computer itself since it had no difficulties with other (non-gaming) programs. A search on the internet yielded many complaints, and finally a suggested solution, which worked for me.

Apparently the hardware graphics acceleration feature of Excel does not always work well with all combinations of hardware and resolutions. To turn this feature off, go to the file tab and then select options at the bottom. Select the advanced options and in the display section there is a check box labeled “Disable Hardware Graphics Acceleration”.

I can’t guarantee that it will work, but Excel now performs in line with other software. Now don’t get me started on DPI scaling behavior.

Bluetooth Frustrations with Windows 10

Not our usual fare, but computer issues are a problem everyone faces.

I was recently forced to rebuild my computer due to a leaky liquid cooler (for the CPU). The new processor required a new motherboard, and since the copy of Windows 8 I was using was tied to the motherboard, I was forced to upgrade to Windows 10 as well. One of the features of the new motherboard was a built in Bluetooth transmitter. Things appeared to be working just fine for the first couple of days. The next day I attempted to use a Bluetooth game controller that I had been using the day before. It refused to connect.

This is what it should look like

I quickly discovered that as far as Windows was concerned my computer did not even have a Bluetooth transmitter. The icon was missing from the notification area of the taskbar. I continued on to Device Manager. It had entries for the Bluetooth transmitter, but claimed that the device was missing.

This led to multiple online searches for problems with Bluetooth and Windows. I discovered that several of the major Windows 10 updates caused a rash of Bluetooth issues. It did not help that the newest update (the Creator’s Update) was just starting to release and some of the troubleshooting information was targeted at that version. The suggested fixes included new drivers, older drivers, checking to see if there really is a Bluetooth transmitter, and making sure the correct services are running. None of these potential solutions worked.

After a couple of days struggling with this problem, I discovered two things. First, my computer had issues with Windows’ fast startup. Secondly, if I unplugged my computer after turning it off, Windows would find the Bluetooth transmitter when I started the computer again. Unfortunately, it would again disappear a few hours later. In the end, I found the solution to the problem on ASUS’s Republic of Gamers Forum (the motherboard manufacturer). A member of that forum, bowman9991, suggested turning off the option that allows Windows to power down the Bluetooth device to save power. This reminded me of a different problem I ran into some years ago when Windows powered down my computer’s hard drive. Several programs would promptly crash to desktop the next time they tried to access the drive. As a result I tried this solution immediately.

This screen is obtained by going to Device Manager (available in the menu produced by right clicking the start button in Windows 10), and then right clicking the Bluetooth device and selecting properties.

This was the solution to my problem. After changing this option, the Bluetooth transmitter has worked flawlessly.

I can only guess that there is some sort of incompatibility between Windows’ power saving programming and the Bluetooth transmitter (or its driver). Unplugging the computer can sometimes clear volatile memory on the computer that is preserved on a normal shutdown, and this apparently includes the power status of the Bluetooth transmitter. I will have to watch for major updates to Windows in the future. They have a habit of reverting settings to their default value. I ended up receiving the Creators Update in the middle of this process and it turned Fast Startup back on.

I cannot guarantee that this will work for you, but it would be worth trying if you are having problems with your Bluetooth transmitter disappearing. It would probably be worth checking whenever there is an issue with a device on your computer. My question is, how many perfectly good motherboards (or other hardware) have been returned or replaced as a result of this power management setting?