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…
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…
Windows Update KB5009546 Totally jacked up our DC.
This update created a ridiculous amount of BS to fix. It created a reboot loop that allowed for about 2 minutes after logging in, shutdown abort command did not work, renamed the machine in certain registry areas, subsequently killing shared folders. It also created renamed the local DNS server with the new generic WIN-* name. This post is for those…
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…
Quickbooks and Server 2016 – Internet Security levels are set to High
Running Quickbooks on a Server 2016 Machine After updating Quickbooks, i received the following alert. Internet Security Levels Are Set Too High The security for Microsoft Internet Explorer has been set higher than the default levels. To use all the feature provided by QuickBooks, you must reduce the security levels for the “internet” zone. Before we can…