Category: Tech Articles

Articles on the topic of technology I’ve written for various personal blogs over the years

  • How to save as Word / Excel / PowerPoint DOC XLS PPT files in LibreOffice

    LibreOffice (and it’s grand daddy, OpenOffice) are excellent programs with a long history in the Open Source community. The projects provide a wonderful inexpensive or even completely free alternative to the power house, Microsoft Office.


    I’m often asked if there’s a way to open your Word, Excel, even PowerPoint files with LibreOffice. The good news is that once you install LibreOffice, it can automatically take over file associations, meaning that when you double click a .DOC (Word ’97-2003) or .DOCX (Word 2007-2016) file, it will open right up in the LibreOffice “Writer” module, just as if it were opening in Word.


    But what about Saving files? By default, LibreOffice uses an ‘Open Document Format’ or ODF Text (.odt) file format to save documents. Although these should open in Microsoft Word, sometimes you send these files to colleagues, friends, or teachers, and the document won’t open on their end, and you catch heat. So the easiest thing to do is to make sure you’re saving all of your files in a compatible Microsoft Word format. Same goes for other document types. I’ll show you how to change the DEFAULT SAVE-AS FILE TYPE in LibreOffice to Microsoft compatible documents (I will provide examples of “Word” and “Excel” compatible files, once you have this down, you will be able to do other formats as well).

    1. With LibreOffice installed (for this example I’m using version 5.0.1.2, September 2015), just click the “LibreOffice” icon on the desktop or in the Start Menu, then click “Writer Document” on the left, to create a new Writer document.
    2. Click Tools from the Menu Bar across the top, then Options at the bottom of the Tools menu.
    3. In the Options Menu, click the “+” sign beside “Load/Save” then click on General underneath that.
    4. At the bottom right, you’ll see an option that says “ODF Text Document.” Click that Drop Down and change it to Microsoft Word 2007-2013 XML (to save as .DOCX), or Microsoft Word 97-2003 (to save as .DOC).
    5. Next, click the drop down box above that, which simply says “Text document” and change it to “Spreadsheet.”
    6. Now change the bottom box from “ODF Spreadsheet” to Microsoft Excel 2007-2013 XML (for saving as .XLSX files), or Excel 97-2003 (to save as .XLS files).
    7. Click OK.

    You can also change “Presentations” to PowerPoint compatible files (.pptx/,ppt). Important when choosing a Microsoft Word, Excel, or PowerPoint format, make sure you do not choose “TEMPLATE” by mistake. You do not want to save your every-day documents as TEMPLATES (an option you can see in some of the drop down list screen shots above), or that will cause issues for the people opening them.


    That should do the trick, though! You now have a fully functional free alternative to Microsoft Office! Enjoy!

  • How to use “Hey, Cortana” with only voice commands in Windows 10

    Now that you’ve upgraded to Windows 10, there’s the “Ask me anything” field at the bottom of the screen, right next to the Start Button. If you click on that, you’ll get introduced to Cortana, your personal assistant. We were promised the ability to activate Cortana by voice, by saying “He, Cortana” – but I didn’t see that option when I first started using the new feature. I clicked the Microphone, and it had me say a phrase so that it could adjust volume levels and learn to understand me better, but nothing was mentioned of “Hey Cortana.” So I did some digging.




    First, you have to click in the “Ask me anything” box, then click on Cortana’s notebook on the left, then click the settings cog icon. Once you’re in there, you can scroll down and enable “Hey Cortana.” By default, it’s designed to listen for any mention of that phrase (meaning she will respond “to anyone”). You’ll notice the option to respond “to me” is probably not selectable, but you can easily click “learn my voice” and speak a half-dozen phrases, saying “hey Cortana” before each one. If you use the same cadence each time, she will learn to better respond only to you, and not every podcast you listen to or jerk friend near by.




    If you have problems, you can always instruct her to re-learn your voice. Also, I’ve noticed that, after you ask a question, such as “hey Cortana — what does the weather in Saskatchewan this weekend?” – the Cortana window will stay up on the screen until you click the “X” in the upper right. OR you can use another command, “Hey Cortana — please close” and the Window will go away.


    It’s also worth noting that, if you speak up, Cortana can hear you over your music, and will pause the music playing to listen to your question. When you’re done, you can say “Hey Cortana — resume music” and Groove Music will pick up right where it left off. I haven’t tested this with Windows Media Player or any other software, yet, but I did find that to be pretty darn handy!

  • No, Windows 10 actually DOESN’T share your networks without your authorization

    I’ve been reading people complaining about this for a few weeks now. It’s completely blown out of proportion, and has been a feature in Windows Phone for over a year.

    The central reason people put passwords on their Wi-Fi is to stop total strangers from sitting in a parked car on the street and using their internet. Wi-Fi Sense, if enabled, allows you to share connectivity with your friends, without having to reveal the actual passwords. If anything, it’s not only more convenient, but safer.

    1. You have the option of turning this service on or off when installing Windows. It’s not hidden in a menu, or (more…)
  • How to DISABLE (or enable?) Wi-Fi Sense in Windows 10

    People have worked themselves into a frenzy, but I have discussed why I think this has been blown out of proportion. Although you should have selected whether or not you want this feature enabled when you first set up Windows 10, if you want to check your settings and change them either to share or lock yourself down, here are some instructions for you!

    First, get in to Windows 10’s Wi-Fi settings. Simply use the search bar at the bottom of the new Start Menu and type wifi, then click “Change Wi-Fi Settings.”

    (more…)

  • How to backup Windows 8.1 before upgrading to Windows 10

    We already discussed whether or not you should take Microsoft up on their offer to upgrade you to Windows 10. In that article, I specifically mention that, although Windows my prompt you to perform the upgrade, even if you want to it, it may be wise to wait a month to see if any headlines emerge with catastrophic upgrade stories, and give Microsoft time to patch the Upgrade process, if so. Perhaps waiting until November of 2015 isn’t so bad. You have a full year to claim the free upgrade, so don’t be in a rush.

    When you’ve decided you’re going forward with the upgrade, it’s a good idea to make sure you’re doing it safely (more…)

  • How to Backup Windows 7 before upgrading to Windows 10

    We already discussed whether or not you should take Microsoft up on their offer to upgrade you to Windows 10. In that article, I specifically mention that, although Windows my prompt you to perform the upgrade, even if you want to it, it may be wise to wait a month to see if any headlines emerge with catastrophic upgrade stories, and give Microsoft time to patch the Upgrade process, if so. Perhaps waiting until November of 2015 isn’t so bad. You have a full year to claim the free upgrade, so don’t be in a rush.

    When you’ve decided you’re going forward with the upgrade, it’s a good idea to make sure you’re doing it safely (more…)

  • How to remove the “Get Windows 10” ad & Icon

    Many users are happy with their computers the way they are and are not interested in upgrading to Windows 10. We’ve discussed some pros and cons, but if you have made up you’re mind that you’re not interested, here’s the best way to get Microsoft to stop bugging you.

    In short, you need to uninstall a particular Windows Update. Microsoft KB3035583 in particular. After it is uninstalled, you’ll need to reboot your computer, search for Windows Updates, then hide KB3035583 to make sure it doesn’t automatically reinstall itself. The step by step instructions are below. (more…)

  • Apple’s insane profits from the iPhone are not an anomaly, it’s a business model

    A friend asked me, this morning, if it was true what he had heard about Apple having less than 20% of sector shipments, but over 90% of smartphone profits. I replied with a simple: “can confirm.”

    Wall Street Journal reported those numbers yesterday, and other sites have been discussing ever since. It’s been pretty widely discussed believed, but this is the first time such numbers were confirmed – and they were even higher than many people suspected. (more…)

  • Should I use the Windows 10 upgrade icon in my system tray?

    UPDATE 1: How to backup Windows 7 before upgrading to Windows 10 & How to backup Windows 8.1 before upgrading to Windows 10 articles have been published!


    Original article below…


    Alright, lots of Windows users have seen a new icon in the System Tray, lately. Recognize this little fella?




    Clicking that brings up the offer from Microsoft to upgrade to Windows 10 for free, beginning July 29th. So that sounds great. But… should you do it?


    First things first, my rule of thumb: if you’re interested in Windows 10, then by all means, go ahead and upgrade! But for people who don’t necessarily like change, here’s my advice: if you have Windows 7 and you like it, ignore the upgrade (I will link to an article, below, to help you ‘hide’ and ignore the upgrade icon). If you have Windows 8 or 8.1? I would say go for it! Even if you don’t like change, I think you’ll appreciate the enhancements Windows 10 offers over 8/8.1. But, there are still some caveats.


    Most importantly, WAIT. Go ahead and “reserve” your Windows 10 upgrade, but wait to install it (it won’t be available until July 29th at the earliest, so you have time to finish reading this article). Windows 10 is “free for the first year” – which means you can reserve your copy now, and after July 29th, you have until July 29th of 2016 to go ahead with the installation at no charge. After that, you’ll have to spend at least $119 to buy the “home edition” and $199 “Professional” edition. But, just because you have it reserved does NOT mean you need to install it right away. This “enrollment program” or “reservation program” will simply download all of the bits to your computer so that it is ready to be installed, and it will pop up a notification letting you know it is ready, but you will have the option of ignoring or delaying the installation. It wouldn’t be a bad idea to wait until, say, September or even all the way until January of 2016, just to make sure any installation errors get the kinks worked out. I think it is important to note that I genuinely believe it’s going to be the most reliable upgrade in Microsoft history, this is the first time Microsoft has been in full control of the upgrade path. No more OEM upgrade, no more worrying about HP or Dell releasing a new version and mailing you a CD, it’s Microsoft actually taking the reigns. However, Windows 10 is going to have a learning curve, certain applications and devices might not work right. It is, after all, a brand new version of an Operating System. Drivers could go missing, or there could be other hardware problems you’re unaware of such as a failing drive, etc…

    So what should I do?

    I’m going to provide additional articles for creating backups of your Windows 7 and Windows 8 computers. If something in the installation process goes wrong, you will need to be able to restore your computer to working order. Stay tuned to this spot for links on how to handle the upgrade from Windows 7, 8/8.1, or how to get rid of that icon if you’re happy where you’re at and you DON’T want to upgrade to Windows 10! UPDATE 1: How to backup Windows 7 before upgrading to Windows 10 & How to backup Windows 8.1 before upgrading to Windows 10 articles have been published!

  • Microsoft “Windows 365” is coming, eventually

    Confirming beliefs that the Windows operating system would be made available as a subscription based piece of software, in February Microsoft officially trademarked “Windows 365” at the United States Patent Office. (more…)

  • Every Windows XP “Windows Update” in one download (+2019 patches)

    Update 3: In May of 2019 Microsoft released a patch for x86 versions of Windows XP and the 32 and 64-bit versions of Server 2003. KB4500705 protects against remote code execution. The patches have been uploaded locally and are hosted further down the page.

    Update 2: Although I have “WannaCry / WannaCrypt” specific patches below, in June of 2017 Microsoft released an additional collection of patches for Windows XP with SP3, Windows XP 64-bit with SP2, and Windows Server 2003. I have not (yet) mirrored these updates locally, but I think it is important to link readers to these critical security patches. Microsoft specifically noted that these updates do not check Windows Genuine Advantage status.

    Original post below:

    As we well know, Microsoft has stopped support for Windows XP – so much so that you can no longer connect to Windows Update and download updates for Windows XP computers. If for some maniacal reason you need to run a Windows XP computer, I would hope you at least get it secured as best you can with the updates. How you ask? I have compiled all of the updates using the WSUSOffline.net tool, and assembled them here (more…)

  • What is DHCP Lease Time and how long should it be?

    Update: Almost 2 years after I wrote this article, it remains one of the most popular on the website, so I put together a brief video explaining what is written below, for the more visual learners out there. Enjoy! 🙂

    Original post below:

    When you’re initially setting up a router, one of the things you might skip over is the DHCP Lease Time setting. It’s typically measured in minutes, but how long should it be set for? What are the advantages or disadvantages of longer or shorter lease times?

    In the average home router, your lease time is set for about 24 hours (1440 minutes). Some people set 8 hour leases, some prefer up to a week! The DHCP lease is how long a device reserves an IP address on your network. The DHCP reservation is the key. The device can leave the network, but the reservation can still be in place, depending on how long you set the lease time.

    It’s a little confusing, so let’s use a few real world examples (more…)

  • How to play .264 video files solved, player here!

    I recently came across the need to play video files saved as .264. After much digging, it seemed I wasn’t alone – and the most common users of these files were people who recently purchased security cameras and were trying to open the video files saved on Micro SD cards from their cameras! You would think an H.264 video codec wouldn’t be so hard to find, but for some reason nothing I tried allowed me to play the file. After some additional research, I found that the company Zmodo is the most common camera manufacturer to do this, and they provide a download of their Zmodo Player software. On the page I link to, as it appears currently, you don’t need to choose an analog or a network product, just look below at the list of “popular tools” and download the ZMD Player / ZPlayer software.


    Just in case they change their website and my link is dead, you can try to search the web for ZModo’s latest version – but if it is needed, the current version as of the time of publication on this article, ZPlayer_1.0.15.0_Setup.exe, is mirrored here on our website.

  • How to export your entire Last.FM Listening and Scrobble history data

    If you were anything like for the last decade, you listened to a lot of music. I had the AudioScrobbler plugin for WinAmp, so that I could use their data tracking to help me discover new music. Then Last.FM bought AudioScrobbler and I got on board with their service, which used Scrobble data from thousands of users to help you discover other music you might like, long before services like Pandora or Beats tried to create a custom channel for you. But now that it looks like Last.FM is on the way out, and that data may still be relevant to you. You may be wondering how you can export your last.fm Scrobble history? Somebody made it quite easy for you. (more…)

  • 2015 Cisco Annual Security Report download

    It’s that time of year again! Cisco has prepared their Annual Security Report.

    My most interesting take away from this year’s report was the shocking number that 54% of companies polled have “had to manage (more…)

  • Will the government notify you that they read your emails? Eventually… maybe.

    Recently, my sister, a Bar-certified lawyer in the state of California, asked me a great question with regards to all of the recent talk about email privacy. She noted that the article says that, if these amendments take hold, that the government is supposed to notify you within 3-business days that they had snooped in your email. But she wondered, what constituted notification? This brought several other questions to my mind, so I did some digging. (more…)

  • iCloud Brute Force password list

    A new tool has been released by a group of hackers that makes hacking things like your iCloud account VERY easy. You may not know you have an iCloud account, but if you have an iPhone, iPad, Macbook, or have ever bought a song from iTunes, you have an iCloud account.

    The hacking tool includes a pre-made list of 500 default password it runs through in a fraction of a second. (more…)

  • FIXED! Sprint ATIV S Neo Developer Preview 8.1 Unable to Activate after Reset

    There has clearly been an issue with Windows the Phone 8.1 Developer Preview and CDMA phones. The issue was discovered a while ago, but it wasn’t an issue you were aware of, typically, until it was too late. My issue was that, after having to “factory default” my phone, it refused to properly reactivate with my carrier, Sprint. I had texting and voice calls, but no data or picture messages. Some research suggested the APN data just needed to be filled in, but calling Sprint resulted in being told that they don’t give out APN information because they provision over NAI, and their support forum was painfully not supportive.

    Complaints aside, there is a way to fix this. (more…)

  • SOLVED: Windows Defender not starting after December ’14 Update

    Update: Microsoft has confirmed that this patch is flawed, and has issued another fix to automatically uninstall KB3004394. Even more fascinating, our experience that this “Windows Defender” update somehow impacted display adapters and video drivers has been confirmed. Continue to read our original post below.

    Just the other day, I had the chance to experience this one hands on. We had a computer that would report that Windows Defender could not start automatically, shortly after the computer had rebooted from recent Windows Updates. Windows Defender in Windows 7 is important because it acts as an anti-malware solution, not just an antivirus. So even if you have something like AVG, Symantec, or even Microsoft Security Essentials, Windows Defender should be allowed to run in the background.

    If you’re tech savvy, you may have even tried to go in to the Windows Services menu and attempted to start Windows Defender manually. If you try this, you will receive an error stating that “The Stub received bad data.” It turns out, there was a flaw in KB3004394, so simply uninstalling that for now will resolve the issue. I will provide the steps for uninstalling that patch.


    (more…)

  • SOLVED: Windows not loading, black screen, bars, 12/2014

    Update: Our theory from the bottom paragraph has confirmed. Microsoft has confirmed that a flawed Windows Update can impact video drivers, and has issued another fix to automatically uninstall KB3004394.

    You may be able to hear sound effects, as though Windows is loading properly, but the screen shows two horizontal bars, and other artifacts and colors occasionally pop up. It appears to be a bad screen or, in the case of our laptop, we thought it was a damaged cable in the hinge. But it turns out this is somehow software related.

    Tap the power key. For us, this shut the laptop down. If that doesn’t work for you, you may need to press and hold the power button until the computer shuts off. Once it is off, boot in to safe mode. You should be able to see the screen in this mode. To do this, follow these easy steps:

    Press the power button, then immediately start tapping the “F8” Key across the top of your keyboard. Tap it at least once a second, if not twice every second… about the time the computer would normally show the “Starting Windows” screen, you should receive a list of options. Stop tapping “F8” then use the arrow keys to select “Safe Mode” (you do not need “Safe Mode with Networking” at this time) and press Enter. Scary text will likely flash up on the screen, but this is normal, eventually, Windows will load. Things will be off color and the wrong size, but this is normal for Safe Mode.

    Now, to fix the Windows Booting issue, you need to remove your display adapter. Again, follow these simple steps:


    Screenshot included for instructive purposes, our actual issue happened on an Intel-graphics based laptop.

    (more…)