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
Excel – How to return the column letter of cell reference
Here is an excel formula to return the column letter of the refereed cell; this one extends to AA, AB ......---> to end: =LOWER(SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")) - small letters or =SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","") - caps
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
Windows XP and Office 2003 – End of Life
Just as a reminder for those out there - Windows XP SP3 and Office 2003 Support Ends April 8, 2014 Read more here...
Read more