Remove OneDrive from File Explorer

To Unlink OneDrive:

You won't lose files or data by unlinking OneDrive from your computer. You can always access your files by signing in to OneDrive.com.

Windows

1. Open OneDrive settings (select the OneDrive cloud icon in your notification area, and then select the OneDrive Help and Settings icon  then Settings.)

2. Go to the Account tab.

3. Select Unlink this PC.

Source: https://support.microsoft.com/en-us/office/turn-off-disable-or-uninstall-onedrive-f32a17ce-3336-40fe-9c38-6efb09f944b0

Google Chrome thinks I'm in another Country

Check in Search Settings that your Region is set specifically to your country (not "Current Region").

 

If the issue persists, you can use this form to report the problem direct to Google.

Thanks to:

bluequoll

Volunteer Contributor - Google Help Communities

https://support.google.com/websearch/thread/136690416/why-does-google-think-i-m-in-a-different-country?hl=en

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

Import photos and videos from an iPhone to PC (works great!)

Import photos and videos from an iPhone to PC

Windows 10

Transfer photos from an iPhone to your PC.

First, connect your iPhone to a PC with a USB cable that can transfer files.

1. Turn your phone on and unlock it. Your PC can’t find the device if the device is locked.

2. On your PC, select the Start  button and then select Photos to open the Photos app.

3. Select Import > From a USB device, then follow the instructions. You can pick the items you want to import and select where to save them. Allow a few moments for detection and transfer.

Make sure the photos you want to import are actually on the device rather than in the cloud. Then, follow the steps for your type of device.

Source: https://support.microsoft.com/en-us/windows/import-photos-and-videos-from-an-iphone-to-pc-2e4e4db4-4c3d-041c-b88f-3ee4358dd95e

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

How to Stop Google from asking if you want to Use your Google Account to Sign in to other Apps or Services

You can disable these prompts from your Google account's permissions page:

This should take you to your own permissions page:

https://myaccount.google.com/permissions

Or go into your Google Account Settings > Security Tab. Here you'll find a section "Signing in to other sites". Select the "Signing in with Google" link to get to your permissions site.

Toggle off "Google Account sign-in prompts" to disable these prompts across the web.

🚀

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

How to Change Default Currency Setting in Google Sheets

This setting is not where you think it should be!

To change the default currency setting to USD in Google Sheets: Click File > scroll down to Spreadsheet Settings > General > Locale.

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

How to fix XBOX No Longer Recording - Error 2184328729

To fix XBOX No Longer Recording - Error 2184328729 on your PC:

This error means you do not have enough room to record any more videos. Delete old videos or move them to a different drive. If you delete videos, BE SURE TO EMPTY THE RECYLCE BIN TOO!

This worked for me, after I emptied the recycle bin... :)

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

Stop Excel from Flashing "CALCULATING" Continuously

If your Excel spreadsheet constantly flashes "CALCULATING" in the bottom status bar, it's possible calls are being made out to a third party. This happened to me when I realized calls to get stock quotes were pinging every 10 seconds or so. To remedy that I created a helper cell. When the value in that cell is "1", calls are made. If not "1" no calls are made.

Thus for example, my TDA Ameritrade call script to get a stock quote looks like this:

        =IF($A$1=1,RTD("tos.rtd",,"LAST",A2),"Not live")

When cell A1 = 1, quotes are updating

When cell A1 does not = 1, "Not live" is displayed

One final note: If you have multiple spreadsheets open, the spreadsheet that's flashing "CALCULATING" is not necessarily the one with the live script, so close them all and work on them one at the time.

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

Pair AirPods with PC - This works!

I always miss one step when trying to pair my AirPods with my PC, so I'm capturing these instructions here. If you don't see your AirPods listed when you are trying to pair them via Bluetooth with your PC, there's likely one step below you are missing. Try again! :)

Pair AirPods with PC

1. On your PC, go to the settings for Bluetooth and make sure that Bluetooth is on (Windows Key + S, type in "Bluetooth and other devices settings")
2. Click the "+" button at the top to "Add Bluetooth or other device", then Click "Bluetooth Mice, keyboards, pens or audio and other kinds of Bluetooth devices"
3. With your AirPods in the charging case, open the lid.
4. Press and hold the setup button on the back of the case until you see the status light flash white.
5. When your AirPods appear in the list of Bluetooth devices, select them.

AirPods should now be paired.

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

AirPods Pro are Paired and Connected, but no sound on PC

AirPods Pro are Paired and Connected, but no sound on PC, check this:

Windows Key + S

Type in: Sound

Select: Sound Settings

Under Output select: Headphones (AirPods Pro)

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

iPhone Photos not syncing to iCloud

Photos you took on your iPhone are not appearing in iCloud. Check that your iPhone is not in Battery Save mode:

General/Settings/Battery/Low Power Mode

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.