Quickbooks typically allows you to open excel reports with macros already enabled. But some of their “other” reports open Excel directly. When it does, it opens the file as a temporary file, and subsequently not a “trusted location” in excel. While it’s easy to get around this, save the workbook to a trusted location (i.e., My Documents) then reopen it…
Category: Tech Blog
Google Play Family Library fails with Minecraft License Error – Android
Minecraft has been a staple in my household for years. It just makes sense our offspring would love it too. We set out to install Minecraft on one of their tablets and to my surprise, no charge, just said: “install”. Great! I assumed it was free from all of the other “marketplace” items for sale now, especially with realms. Come…
Excel unable to enable Macros when running QuickBooks Report.
Our most recent edit shows you the folder to specifically trust: http://strongitguy.com/quickbooks-set-excel-to-open-with-macros-enabled-when-running-reports/ User goes to open up an Excel report from Quickbooks and receives a Security Warning that Macros have been enabled. There are two ways to “Fix” this based on your security settings and environment. The first is the easiest for most users. For this, we are going…
Removing Unfinished files with Backblaze B2 CLI
Step 1: Download Backblaze B2 Command Line Tool Remember DURING install to choose to set PIP environmental Path https://www.backblaze.com/b2/docs/quick_command_line.html or https://www.backblaze.com/b2/docs/quick_command_line.html#download If you run into issues with PIP: http://strongitguy.com/issues-setting-up-b2-command-line-and-windows-python-install/ Backblaze documentation has an [-h] in it, remove this. b2 authorize-account ID Appkey (replace ID and APPKEY with the one you received from Dropbox) Commands to run once CLI…
Issues setting up Backblaze B2 Command-line and Windows / Python install
I needed to set up the Backblaze B2 command-line tool to remove unfinished files, also known as failed uploads. The only way to clear out “unfinished files” is to run their designated script from the command line. If you don’t, you will end up using up a lot more space and money than you want. Backblaze has a write-up on…
DJI Phantom USB Modem for RTK Controller
DJI Phantom 4 Pro RTK – a WORKING dongle, and how we set it up. Company recently purchased a DJI Phantom 4 Pro w/RTK. The Controller requires a USB Dongle to communicate with a cell network to work with RTK. Our service provider is AT&T, but this should work with Verizon also. The DJI manual states under Dongle: A dongle…
Office 365 Account Error – we can’t get to your account right now
Symptoms: User continued to have issues opening word or excel from SharePoint. At times it would ask for credentials, you would enter a username, then the screen would disappear without a password request. Other times it would open, but would not let them edit the document. Errors: Account Error Sorry, we can’t get to your account right now. To fix…
How to configure a Dell DPWC400 NVMe PCIe SSD adapter in RAID 0
How to configure a Dell DPWC400 NVMe PCIe SSD adapter in RAID 0 Open Command Prompt ->Diskpart ->List Disk Disk ### Status Size Free Dyn Gpt ——– ————- ——- ——- — — Disk 0 Online 238 GB 0 B * Disk 1 Online 238 GB 0 B * Disk 2 Online 238 GB 0 B * Disk 3 Online 238…
Robocopy Hides Destination Folder
The root cause is you are transferring from the root directory. There are many suggestions on how to fix/correct/prevent this but /A-:SH Did not work /A:-SH errors out Excluding “System Volume Information” Did not work Fix: run cmd from the parent folder of the hidden folder notice it starts at that path! 😀 run the following command: attrib -R…
No internet access on virtual machine using Hyper-V
No internet access on virtual machine using Hyper-V You setup Hyper-V but none of your VM’s seem to have internet. You have your ethernet cable in port one, and you have your Hyper-V Virtual Switch Manager properties reflecting NIC1. Sound familiar? Windows will not always keep the correct structure for the NIC naming. The errors you might receive: Unidentified…
