Fixes, Quickbooks, Tech Blog, Tech Random's, Tips and Tricks

Quickbooks – set excel to open with macros enabled when running reports.

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…

Continue Reading

Android, Fixes, Microsoft, Tech Random's, Tips and Tricks, Uncategorized, Weird Tech Issues

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, it said: “install”.  Normally indicating no costs. Great!  I assumed it was free from all of the other “marketplace” items for sale now, especially with…

Continue Reading

Uncategorized

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…

Continue Reading

Microsoft Excel, O365, Tech Blog, Tech Random's, Tips and Tricks

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…

Continue Reading

Backups, Tech Blog, Tech Random's, Tips and Tricks, Uncategorized

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…

Continue Reading

Dell, RAID, Tech Blog, Tips and Tricks

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…

Continue Reading