Kent's Repository A Compilation of Life's Problems and Solutions and other things…
Browsing all posts in: Microsoft Office

Manually remove sheet protection from an Excel workbook

March 9

For Excel version 2010 and below, an easy VBA macro can be used to generate a compatible password to “un-protect” a worksheet. The macro that is floating around the internet does not actually reveal the password, but generates another password that will authenticate the same way to Excel. This was possible due to a weakness in the excel password system where it hashed passwords into a weak algorithm (Explanation Here).

For later version of Excel, “un-protecting” a worksheet became a little tougher, but still doable. The reason it’s possible to remove the sheet protection is because protection does not equal encryption, a protected sheet is not encrypted. Encryption is a totally different animal and not one that I have an easy answer for. But if you’re just looking to remove sheet protection, then chances are it can be done.

Read the rest of this entry »

Microsoft Office Freezing or Lagging?

July 20

If your Microsoft Office products are freezing, lagging or behaving strangely, the issue may be with hardware graphics acceleration. We’ve seen issues involving Windows 8 and Nvidia Graphics chipsets, in all cases, disabling hardware graphics acceleration in the Microsoft application solved the problem. It’s possible that a drive update will be released to fix these issues but in the mean time, here is the solution.

Read the rest of this entry »

Useful Excel Functions: Unhide all hidden worksheets

December 2

This one comes to you compliments of

The following short VBA code also can help you display all of the hidden sheets at the same time.

1. Hold down the Alt + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste the following macro in the Module Window.

Sub UnhideAllSheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Visible = xlSheetVisible
Next ws
End Sub

3. Press the F5 key to run this macro. And the hidden sheets will be displayed at once.

Read the rest of this entry »

Multiple Exchange Accounts in Microsoft Outlook

November 25

With Outlook versions before 2010, you were limited to having 1 Exchange Type Account (mailbox) per profile. In this case, adding additional mailboxes was handled exclusively through the “add additional mailbox” option in the exchange account settings. However, this would only work if both accounts existed on the same exchange organization.

Beginning with Outlook 2010, you are now allowed to add multiple exchange accounts, this solves the problem of having multiple exchange accounts, on different organizations. However, adding multiple delegate email addresses for each exchange account now becomes a problem. Adding additional or delegate mailboxes for the first exchange account that was added in the profile works fine, however the “add” button in the additional exchange accounts is grayed out or disabled.  Here is a solution courtesy of and Microsoft


Read the rest of this entry »

Useful Excel Functions: Substitute Multiple Characters

November 5

Normally, the excel substitute() function is limited to finding 1 string and substituting said string for another string. This Excel User Defined Function allows you to substitute multiple sets of strings/characters. I created a sheet with 2 columns (as named ranges), “CleanOLD” and “CleanNew” and used the following formula =SubstituteMultiple(TRIM(CLEAN(A1)),CleanOld,CleanNew)

Excel Multiple Substitute

Read the rest of this entry »

Window/Orphan Control: Obscure Microsoft Word option

June 21

A user called in today with a Microsoft Word issue, we don’t usually support Microsoft Word but most “issues” end up being very simple fixes. The issue today was that he user was unable to start the beginning of a paragraph at the end of a page, without the entire paragraph being shifted to the next page. Not ever having encountered the issue myself, I suggested two fixes

1. Shift Enter instead of “enter” at the EOL of the previous paragraph. This inserts a line break instead of a paragraph break.

2. The old Microsoft Word “Make-it-Fit” tool, which for-whatever-reason, Microsoft has made difficult to find. It looks like it’s been renamed to “Shrink to Fit”

Apparently option #1 worked but it caused issues with the user’s formatting, option 2 did not do much. The user was able to stumble upon a “paragraph” option in word which I’ve never used before, the solution was “Window/Orphan Control”. Here are some links that explain options 1-3:

Read the rest of this entry »

Email that you send on behalf of someone is not saved in their Sent Items folder

May 15

Are you responsible for multiple exchange (e-mail) mailboxes? Tired of sent items not going into their corresponding sent-box? Here is the solution for Microsoft Outlook

Email that you send on behalf of someone is not saved in their Sent Items folder


This also works in newer versions of Outlook, just locate the appropriate registry key version.  Microsoft FixIt will also make the changes for you locally