Tag Archives: Office

Installing Office 2019 – with MAK Key

Here are a few steps required to install Office 2019 with MAK license of Office. Download and run the Office Deployment ToolIt will create the configuration.xml (See example below for edits you will need to do).Open a Admin privileged command prompt and navigate to the location of the setup.exe and configuration.xml files (Both files should…
Read more

Microsoft Office 2016, crashing, freezing issues

If you have Microsoft Office 2016 and are having crashing, freezing issues (mainly with Word or Outlook), 99% of the time it's due to not getting Office updates. Especially if you bought the office suite with your computer. UPDATE: If you have ANY other version of Office installed (Ex: Office 2010, 2013, etc.) this is…
Read more

Excel – Lookup value in column and return value from another column

You can build a lookup that allows you to specify the lookup column and return value column completely independently, and also control of the nature of the approximate match, if not exact. Here is the full function: =INDEX(Return_value_range, MATCH(Lookup_value, Lookup_value_range, Match_type)) Return_value_range – The range that holds the return values Lookup_value – The value you…
Read more

Outlook 2010 Only Starts in Safe Mode

Microsoft has withdrawn the yesterday released Windows Update KB3114409 because it causes Outlook to start in Safe Mode. This loads the email client without customization and plugins. Fortunately it can be easily fixed. This can be done this way: Go to your Control Panel. Go to ‘Programs and Features’ and left click ‘View installed updates’.…
Read more

Configuring Outlook for Windows to Prompt for an Exchange Password

Needed to set your Outlook (with an MS Exchange e-mail account) to ask you for your password each time you open it, here you go: Start Outlook. To View the accounts… In 2010/2013: Select the File tab. Click the Account Settings button. From the drop-down list, select Account Settings... Select your Exchange account. Click the…
Read more

Unprotect an excel sheet without password

If you have ever protected an excel sheet; forgot the password or got a excel sheet and needed the password to edit it, here is how to "unlock it": http://uknowit.uwgb.edu/page.php?id=28850 Here is the VBA code that you will need to crack and show you the password: Sub PasswordBreaker()     'Breaks worksheet password protection.     Dim…
Read more