Computers – The Worried Bird

Skip to content

# Tag: Computers

## 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.

## Annoying Ads

While I prefer advertising to having to pay half a cent (or whatever it would cost) a page to view sites on the internet, there are some behaviors that annoy me. Some sites use cookies in an attempt to harvest data and predict what kinds of products I wish to hear about. They have their own problems, but at least they are focused on the actual computer. Other sites appear to track IP addresses, leading to a very annoying problem.

When cookies are local to the computer in question it is possible to disrupt them somewhat by removing the unwanted cookies and using browser modes which at least attempt to limit them. While they can be more detailed, the important thing is they only affect one device (unless something like a social media app with a login gets involved). This means that unless the computer is shared, the tailored ads only appear on that one computer.

Now we come to the problem with what I assume to be IP address tracking: gift buying. I search for the gift in question. Then suddenly every computer/tablet/phone in the house suddenly starts showing ads for that product. There goes any chance of a surprise gift. Very annoying.

## Watch Your Windows 10 Settings

A problem with the semiannual content packs is settings changes

The semiannual updates to Windows 10 have good points and bad points. They tend to come with new features, which depending on your interests can be a very good thing. They also come with problems, and I am not talking about the bugs which come standard in any new software.

The biggest problem I have with the updates is that settings are changed. I initially had problems with Bluetooth on my computer. Windows was turning the device off and forgetting about it. In diagnosing a problem, I discovered that my motherboard, targeted at all operating systems and not just Windows, wasn’t compatible with Fast Startup in the configuration I was forced to use. (The Windows focused mode didn’t like the SSD I was using). To avoid issues with improper shutdowns, I turned fast startup off. During my debugging I did a manual Windows Update in case the problem had been fixed in the update. It triggered that Spring’s Creators Update. After it installed, the error messages were back. The update, without any notification, had turned fast startup back on.

As a result of this, I looked through the various settings I have customized on my computer. This Spring’s problem was with the lock screen. While some of these changes are deliberate, other changes appear to be random. The important point is, while enjoying any new features you like, make sure that your settings have not been changed before they cause problems.

## 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?

Loading Comments...
Write a Comment...
Email (Required)
Name (Required)
Website