Category Archives: Office

We’ve run into a problem with your Office 365 subscription after tenant to tenant migration.

After a tenant to tenant migration multiple people got the message ‘We’ve run into a problem with your Office 365 subscription’.

I found a script wroted by someone on;
How to resolve “We’ve run into a problem with your Office 365 subscription” with PowerShell

So to resolve this issue you start powershell on the PC that has the problems and run the following command.
set-executionpolicy unrestricted

Then create an .ps1 file with the following code

<# .SYNOPSIS This script locates OSPP.vbs and removes all product keys to trigger O365 reactivation. It will remove ALL product keys. .NOTES File Name: Author : Johan Dahlbom, johan[at] Blog : The script is provided “AS IS” with no guarantees, no warranties, and they confer no rights. #>
#Check that the script runs with privileged rights
if (-not([Security.Principal.WindowsPrincipal] [Security.Principal.WindowsIdentity]::GetCurrent()).IsInRole([Security.Principal.WindowsBuiltInRole] "Administrator")) {
Write-Warning "You need to have Administrator rights to run this script!`nPlease re-run this script as an Administrator in an elevated powershell prompt!"
#Find OSPP.vbs path and run the command with the dstatus option (Last 1...)
$OSPP = Resolve-Path -Path "C:\Program Files*\Microsoft Offic*\Office*\ospp.vbs" | Select-Object -ExpandProperty Path -Last 1
Write-Output -InputObject "OSPP Location is: $OSPP"
$Command = "cscript.exe '$OSPP' /dstatus"
$DStatus = Invoke-Expression -Command $Command

#Get product keys from OSPP.vbs output.
$ProductKeys = $DStatus | Select-String -SimpleMatch "Last 5" | ForEach-Object -Process { $_.tostring().split(" ")[-1]}

if ($ProductKeys) {
Write-Output -InputObject "Found $(($ProductKeys | Measure-Object).Count) productkeys, proceeding with deactivation..."
#Run OSPP.vbs per key with /unpkey option.
foreach ($ProductKey in $ProductKeys) {
Write-Output -InputObject "Processing productkey $ProductKey"
$Command = "cscript.exe '$OSPP' /unpkey:$ProductKey"
Invoke-Expression -Command $Command
} else {
Write-Output -InputObject "Found no keys to remove... "

Then you can launch the script via powershell and all should be fine.

Allow synchronisation of files with special characters (like # and %).

Allow synchronisation of files that include special characters in the filenames, like # and %.

Step 1; Download and install the ‘SharePoint Online Management Shell’

Step 2; Open the SharePoint Online Management Shell by searching for ‘sharepoint’ in your startmenu.

Step 3; Run the following command: (replace the values according to the tenant you are connecting to)

$userCredential = Get-Credential -UserName $adminUPN -Message "Type the password."
Connect-SPOService -Url https://$ -Credential $userCredential

Enter the password, click OK and press ENTER.

Step 4; Run the following command:

Set-SPOTenant -SpecialCharactersStateInFileFolderNames Allowed

All done, it can take hours or even a couple of days to get the files to sync after the change.

Outlook – Pressed backspace, where did my email go?

When you (accidently) press ‘backspace’ within Outlook you will see your highlighted email dissapear.

You will not find it in deleted items or even in restore deleted items, because it’s in your ‘Archive’ folder within your profile.

Find your ‘Archive’ folder and you will see the message you just pressed ‘backspace’ on.

Outlook 2016 – Upgrade in Progress

Recently i faced some Outlook 2016 functionality issues. It became impossible to sent / receive email.

In Outlook 2016 options there was a message ‘Upgrade in progress’ This could be there for days without any change.
Some websites are saying that opening Outlook in /safe mode is resolving the issue, this was not the case for me.

The solution for me was:

start -> run -> regedit
go to HKEY_CLASSES_ROOT\Installer\Components\F1291BD604B860441AB89E60BDEE0F9C
right click -> permissions
‘add’ the current user or ‘everyone’ and give it READ permissions.

Open Outlook 2016 and all should work fine.

Office365 – Create a roomlist

If you have multiple rooms in your Exchange Online environment you want to use roomlist(s).

To create a roomlist first connect to powershell:

Connect to Office 365 using Windows Powershell

To create a roomlist enter the below command:
New-DistributionGroup -Name “New RoomList” -Roomlist

You will now have a roomlist, but the list is empty. To add room’s to the list enter the following command:

Add-DistributionGroupMember -Identity “New RoomList” -Member “Room 1”

You will need to enter the above command for each room you want to add to the list.

How to turn Clutter feature on / off for all users via PowerShell

First, connect to Office365 / Exchange via PowerShell.

To turn Clutter on:
Get-Mailbox | Set-Clutter -Enable $true

To turn Clutter off:
Get-Mailbox | Set-Clutter -Enable $false

To see if it worked, you can get the Clutter status by typing:
Get-Clutter -Identity

Office 365 – How to see the creation date of a mailbox via Powershell

Open powershell as administrator and connect to office 365.

See here how to do it:

Then when connected typ in this command:
get-mailbox -id userID | select whenCreated

Office 365 – Force DirSync synchronisation / update

DirSync will automaticly update passwords every 2 minutes and other users / settings every 3 hours but sometimes you want to force it.

To do that open Windows Powershell and go to:
PS> cd “C:\Program Files\Windows Azure Active Directory Sync\Sync”
PS> .\ImportModules.ps1
PS> Start-OnlineCoexistenceSync

Thats it!

Office 2013 – Slow in RDP / RDS

In a terminal server session (RDP / RDS) Outlook, or the whole Office 2013 suite seems very slow in comparison with Office 2010.

To workaround this issue you have to change your RDP-Display options to 16 or 24 bit (32bit is default).

To do this:
Open ‘remote desktop connection'(mstsc)
Choose ‘Show options’ -> Display -> and at Colors Choose ‘High Color 16bit’ or ‘True Color 24bit’.

Reconnect to your sessions and Office 2013 should be a lot faster.

Outlook 2010 – Anonymous security option missing

When you are trying to configure Office 365 in Outlook 2010 there is a change the ‘anonymous’ security setting is missing. This will result in a setup faillure when trying to log in to office 365 account. So you can’t setup office365 via either autodiscover or manual.

To resvolve this issue i did the following:
1. Install SP1 for Outlook 2010.
2. Reboot
3. Install this patch:
4. Install this patch:
5. Reboot

When you try to configure office 365 in Outlook 2010 it will work!