Tech Review: 240GB King Dian Portable SSD

Hi Everyone,

I recently purchased a little portable SSD for making it easier to transport files. I have made a little tech review video for the product. Please check it out below.

If you are interested in this device and would like to support my channel and site please use the affiliate link:

Or if you just want to buy the SSD you can go to:

Excel Formulas Not Updating

I come across a user with a peculiar issue when updating fields in a excel document the formula values would not update automatically. As it turns out this is a super easy issue to resolve. In office 2016 / 365 you just need to go to the Formulas tab and then Calculate Options. Under that menu item drop down you can set the formula calculation back to Automatic.

Hiding Users from AD Synced 365 GAL

I came across an issue today where I needed to hide some old users email accounts that had been converted to shared mailboxes. However with our office 365 we don’t have full 2 way synchronization enabled. As a result when you go to the 365 portal and attempt to hide the user you get a big error message instead of a pat on the back for a job well done.

Instead what you need to do is:

  • Go to a domain controller and fire up Active Directory Users and Computers
  • Browse to the user in questions
  • Right-Click on the user and select Properties
  • Navigate to the Attribute Editor tab
  • Locate the msExchHideFromAddressLists item and click Edit
  • Set to False and click OK and then OK again to close and save the user changes

After this you will just need to wait for you AzureAD sync to occur and the changes to process.

Group Policy Issue – Windows 10 April 2018

There appears to be a weird issue where in the April 2018 release of Windows 10 group policy fails to refresh the user part of the group policy. Instead you get the message below

This is caused by the netlogon service not running (and being set to manual?!). To resolve the issue you need to do the following:

  • Press Win + R on the keyboard to open the run window
  • Type in services.msc and click run
  • Scroll down and look for Netlogon, if the status is not Running, then that’s why you’re getting this issue
  • Double-Click on Netlogon and change the Startup Type to Automatic and click the Start button
  • Once the service is running, click the OK button
  • Now try running gpupdate again

If you have a large number of computers running Windows 10 and want to fix them all you can make this change using group policy. To do so carry out the following in an appropriate Policy object

  • Start Group Policy Management on a Domain controller
  • Select the appropriate group policy
  • Select Computer Configuration > Preferences > Windows Settings > Services
  • Add a new service and use the following settings
    • Startup: Automatic
    • Service Name: Netlogon (you can pick from the list)
    • Service Action: Start Service
  • You can also set the service to restart on failure by going to the Recovery tab
  • Click  OK

All going well this should resolve the group policy issue. If this helped you please let me know!

Auto login a domain joined computer

Every now and then you come across a situation where you just need a computer to log in and start an application without user intervention. While it is not ideal from a security point of view sometimes it is a necessity. On a non domain joined computer you are able to use the netplwiz command to setup an automated login. However on a domain joined computer this option does not exist. To do the same on a domain joined computer you need to use the regedit as administrator. Once open you need to browse down to the follow location “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon“.

From here there is 4 entries you need to change to suite your needs.

  1. AutoAdminLogin – Needs to be set to 1 to enable auto login
  2. DefaultDomain – Needs to be set to the domain you are logging into (either PC name or AD name)
  3. DefaultUserName – Needs to be set to the user that you want to autologin
  4. DefaultPassword – Needs to be set to the password of that user account. Be aware that this is kept in plain text and can be looked up by any user with access to the registry! If this registry entry is not there you need to add it. (This is just a string registry item.)

After this you can restart the computer and if it is all configured correctly it will login with the user that was specified. You can disable the auto login also by changing the AutoAdminLogin to 0


Error changing print driver Server 2012/R2

I have had a issue that has been plaguing me the last few days where I was unable to update the printer drivers on a shared printer. With the error message “Printer settings could not be saved. This operation is not supported.” After a bunch of searching I found that if you unable to change the printer drivers on a Windows Server 2012/R2 Server you need to first untick the share option on the printer. The change the drivers for the printer. After which you can re-share the printer on the network / directory.

Kudo’s go to as they had the above information on their blog.

Modify a distribution group members in Outlook

Accessing the Distribution List

  1. Selecting the Home tab and click on the Address Book
    Fig 1. The Home tab
    Fig 2. The Address Book option on the Home tab
  2. In the Search section enter the display name of your distribution list. E.g. QualityCommittee
    Fig 3. The Search field in the Global Address List (GAL)
  3. Double click on the distribution list or right click and the select Properties. The details of the central distribution list will be displayed in a new window.
    Fig 3.  Example of a central distribution list and location of the Modify Members button
  4. Click on the Modify Members… button

Adding Members to the Distribution List

  1. Click Add… and then search for the name or user ID of the person you want to add.
  2. Once you have found the person you want to add either double click on their name or highlight the name and click Add.
  3. Once you have the people in your list that you want to add click the OK button.
  4. You should then see them on the list. Click OK.
  5. Click OK again to close the properties window.

Removing Members from the Distribution List

  1. Search through the list for the person you want to remove. Highlight their name.
  2. Click on the Remove button.
    Click OK.