Author Archives: J.D. H.

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

Rotate a tablet screen when using TeamViewer or remote work software

Summary: sometimes a PC or tablet may be stuck in the wrong screen orientation when you log in via TeamViewer or other remote software. Solution: Turn rotation lock ON Rotate via the “orientation setting” Apply settings and you are done! Details: Recently I had to do some work for a client via TeamViewer. While that is normal, the ruggedized tablet that I was logging into was a little out of the usual. Specifically, the tiny tablet was running Windows 10

Photoshop JPG file sizes are way too BIG!

Recently I received an unusual JPEG for a work project. The resolution was fairly low (1344×576) and the document resolution was also set to a relatively low screen resolution of 72dpi: Normally I would anticipate this file being less than 1MB. However, it was over 10MB! Copy and pasting the image content into a blank Photoshop file and saving as a JPEG also resulted in a 10MB file size. Even using a very high compression level (and thus reducing the

Google Photos crashes when saving edits on Samsung Note 10 (S10, S9, S8) [SOLVED]

Recently my wife unable to save photos after editing them in Google Photos. Specifically, the Google Photos app would crash immediately upon trying to save edits and this issue was occurring on a Samsung Note 10+. Checking with some friends, they were having similar issues on their S10 phones. After trying a number of adjustments (restarting, clearing cache, clearing data) I finally realized that the issue was due to motion photos. Specifically, during a recent software update, it seems that

Q. How can I copy photos from internal memory/storage to SD card?! [SOLVED] Fuji

Q.How can I copy the pictures stored in the internal memory on my FujiFilm FinePix HS 50 EXR (or similar) to memory (SD) cards? Answer: The procedure to copy the pictures in the internal memory to a memory card is as follows: After copying, the pictures will remain in internal memory. Delete them if necessary. 1. Install a memory card into the camera. 2. Press the playback button to enter playback mode. 3. Press the MENU/OK button to open the

How to fix the fatal error allowed memory size exhausted [SOLVED] (PHP)

How to fix the following memory size error on turnkeylinux (or similar)? ( ! ) Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 80 bytes) in /var/www/fit2019/index.php on line 2841 Call Stack # Time Memory Function Location 1 0.0015 510656 {main}( ) ../index.php:0 2 0.0153 523256 funcMakeTableTotal2019( ) ../index.php:487 3 2.0429 33543952 mssql_fetch_assoc ( ) ../index.php:2841 Answer:Edit the configuration file: /etc/php5/apache2/php.ini and set the memory limit to a value higher than 32M: memory_limit = 128M Then

Improve Lenovo PC performance, remove McAfee LiveSafe, replace with best Antivirus

Recently we purchased some new Lenovo AIO PCs with Windows 10. These systems have nice Ryzen CPUs, SSDs and plenty of RAM but there is still room for performance improvement! One of the first things I like to is uninstall programs that I do not need. There are a ton of candidates but McAfee LiveSafe is one of the first that I uninstall. It takes up precious resources and nearly a GB of space on the SSD. Uninstalling is quick