Category Archives: Uncategorized

How to fix Microsoft Excel’s “File not loaded completely” error message [SOLVED]

A client recently reached out to me with the following problem: When importing a large (72MB) CSV document, Excel reports “file not loaded completely”. 🙁 Sure enough, data is missing. Can you help me? This issue is caused by Excel only supporting ~1,048,576 rows in a CSV file. In the client’s instance, there were around 1.6 million records. Thankfully, for Excel’s limitation, there is a relatively simple workaround: Open the CSV file in a text editor that supports large file

Intel NUC will not recognize mouse/keyboard on Windows 7 install

Article to be updated… Here is a copy/paste of some of the commands… dism /mount-wim /wimfile:boot.wim /index:2 /mountdir:mount dism /image:mount /add-driver:”USB3″ /recurse dism /unmount-wim /mountdir:mount /commit dism /mount-wim /wimfile:install.wim /index:3 /mountdir:mount dism /image:mount /add-driver:”USB3″ /recurse dism /unmount-wim /mountdir:mount /commit streams64 –s –d USB3 Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation.  All rights reserved. C:\Windows\system32>cd C:\USB3 Fix C:\USB3 Fix>dir  Volume in drive C is 500GB_MX100  Volume Serial Number is 0E6E-F717  Directory of C:\USB3 Fix 02/11/2019  10:18 AM    <DIR> 

Ultimate Holiday Eggnog Latte

This awesome latte can do double duty for Christmas or New Year’s. Simple to make and delicious to drink. My wife says it is head and shoulders above StarBucks eggnog latte. Our friends say it brightens up their holidays. Here is the recipe: (makes 2-4 cups depending on your espresso maker/bialetti) *note: this entire recipe costs about $0.25 a cup in ingredients and requires minimal equipment. Ingredients: +Medium coffee (can also use decaf) +Whole milk (substitute soy milk, oat milk

How to enter the BIOS on Windows 10 Lenovo Laptops

Some recent Lenovo laptops lack a keyboard hotkey to enter the BIOS. Instead, the laptops utilize a dedicated “Novo” hardware button on the side of the machine. Press the dedicated button to access the BIOS. Here are specific instructions for entering the BIOS or selecting the Boot Menu on a modern Lenovo laptop: Power OFF the laptop Press the Novo button* *it may be on the left or the right side of the laptop Voila, you can now enter the BIOS