Home Blog

Word opening Compatibility Mode for all documents even NEW


Try this first:

Convert your “Normal” template to the current office version

The Normal.dotm template is stored in a hidden folder. The simplest way to open it is this way:

  • Open a blank document and Press Alt+F11 (opens the macro editor)
  • Press Ctrl+G to open the Immediate window at the bottom of the editor
  • Type this into the Immediate window and press Enter:


  • You should see the normal.dotm file open up in its own window. Go ahead and close the macro editor window and switch to the normal.dotm window. Check the Title Bar. If it says [Compatibility Mode], go to File > Info and click the Convert button. Then save and close the template. This fixes Compatibility Mode issues with new documents.

    If older documents still show [Compatibility Mode] and you are planning to use new features in those files then you can use File>Info and Convert those as well. In most cases you will not need to Convert them.

Excel crashing with video driver error Intel Graphics HD 530


This note is regarding crashes of Excel on Windows 7 when searching rows and columns. Excel will crash with a video driver error (also Skype crashes).

The fix appears to be newer drivers for the Intel chip (when installing, some people recommend to untick the box to enable Aero), but if you still have issues as some people do, you can hack the registry to increase the timeout of the video driver.

From Microsoft’s site here:

To Change the Graphic device timeout, use the following steps.

  1. Exit all Apps and Programs.
  2. Press the WinKey+R keys to display the Run dialog.
  3. Type  regedit.exe  and click OK to open the registry editor.
  4. Navigate to the following registry key:



  1. With the GraphicsDrivers key selected, on the Edit menu, click New, and then select the following registry value from the drop-down menu specific to your version of Windows (32 bit, or 64 bit):

(NOTE: The TdrDelay name is Case Sensitive)

For 32 bit Windows

a. Select DWORD (32-bit) value.

b. Type TdrDelay as the Name and click Enter.

c. Double-click TdrDelay and add 8 for the Value data and click OK.


For 64 bit Windows

     a. Select QWORD (64-bit) value.

b. Type TdrDelay as the Name and click Enter.

 c. Double-click TdrDelay and add 8 for the Value data and clickOK.


Close the registry editor and then restart your computer for the changes to take effect.

View Shared Outlook calendars on iPhone iOS


The setup:
Exchange Online user. Has a secondary shared calendar in their account which is shared with other team members with access to put items on it.

The need:
Team members would like to use the calendar from their mobile devices, but it doesn’t show on theirs, only shows on the owner’s mobile.

The fix:
Have the owner un-share it, then Send a sharing invitation in email to re-share it with each team member from the Office Online Calendar interface. Make sure you select the proper permissions for that user.

On your mobile, use the Outlook App(iOS and Android) and open the “I’d like to share my calendar with you” email and then add the shared calendar to your account.

Reference: https://support.office.com/en-us/article/Share-your-calendar-in-Outlook-on-the-web-for-business-7ecef8ae-139c-40d9-bae2-a23977ee58d5?ui=en-US&rs=en-US&ad=US#__toc375064923

PS. Beware of advice to publish your calendar to the web and use the link…I haven’t studied all the ramifications of doing this, and naturally it depends how sensitive your calendar info is, but in general I’d advise against this unless you are sure it’s what you want.


If you’re looking for some general guidelines on how to add a calendar from a Shared Mailbox to iOS then refer to this link here: http://help.unc.edu/help/accessing-a-shared-calendar-on-ios/
Note: the steps in the link above will publish your calendar to a direct link which is considered insecure because it can potentially be shared with others outside your organization.

Microsoft Outlook 2016 Office 365 hang on processing


Over 400 people found this tip helpful…

  • Close Outlook, Right-Click on Outlook icon. Select “New Email Message”.
  • Keep it open. Right-Click on Outlook icon. Select “Outlook 2016”, should open fine.
  • Close the email message window and Outlook and test after that..should be OK.

If this doesn’t work…google some more!

*Special thanks to Eric Saenz via answers.microsoft.com

Office 365 Remove a search for in-place eDiscovery and hold after mailbox deleted


You place the mailbox on hold, but delete the mailbox. The search cannot be removed while there is a hold. So..you need to remove the hold. You can do this with a remote powershell session and this command:

Set-MailboxSearch -Name Searchname -InPlaceHoldEnabled: 0

Wait a minute, refresh the compliance page and the in-place hold should be = NO
Then you may delete the hold.

*Remote Powershell*
Open PS in administrative context
Run: Set-ExecutionPolicy RemoteSigned
Then Run:
$LiveCred = Get-Credential
$Session = New-PSSession -ConfigurationName Microsoft.Exchange-ConnectionUri https://ps.outlook.com/powershell/ -Credential $LiveCred -Authentication Basic -AllowRedirection
Import-PSSession $Session

NOTE: When prompted for credentials, enter your Office 365 admin username/password or one that has admin rights for the tenant.

Store iPhone backups in the cloud or in DropBox (PC)


A client approached me to inquire about using cloud storage for, well, everything. They wanted their laptop to dock with a USB hard drive that was synced with DropBox (cloud storage). Since they have an iPhone, naturally they wanted to see about storing iPhone backups in the cloud.

My first thought was, your backups need to be Encrypted. After that, store them wherever you’d like! Of course, if you don’t wish to store them locally (Apple default save directory), then you can make one simple change to your system which will redirect where iTunes stores those backups. To make this happen, we use a Symbolic link – which is a type of Shortcut that tells the File System to look in another place for the folder iTunes is expecting to save your backup in. It’s completely transparent to iTunes.

For PC

iTunes backups are stored in “C:\Users\*USERNAME*\AppData\Roaming\Apple Computer\MobileSync\Backup”

To move this folder’s location:

  • Copy the folder to the new location (for example: the DropBox folder on your USB drive)
  • Either keep the original folder name of Backup or rename to something more descriptive. I like “iPhone Backups”
  • Go to the original folder location “C:\Users\*USERNAME*\AppData\Roaming\Apple Computer\MobileSync\”
  • Either delete the folder “Backup” or rename it “BackupOld” to keep it
  • Press Shift+Right Click and select the option to open a Command window here
  • Type the following command:

mklink /J "%APPDATA%\Apple Computer\MobileSync\Backup" and "<DropBox path>:\iPhone Backups"

  • Close Command prompt
  • Launch iTunes and see if it locates the backup

Note: Make sure you check your cloud storage for the backup as well. It may take a while to upload.


For Mac instructions, please use this excellent resource: https://support.imazing.com/hc/en-us/articles/203504123-Storing-your-iPhone-Backups-on-an-Alternate-Location

FileZilla cannot View Edit Excel documents remote document


This issue arises with FileZilla possibly due to lack of native support for the XLSX file extension. The fix is to manually map the associations for Excel in FileZilla (you may not need both, but I included xls for good measure):


  • In FileZilla goto Settings, then File Editing / File Type Associations
  • In the Custom filetype associations pane, enter in the following:
    • xls “C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE”
      xlsx “C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE”

Obviously you will need to use your own path for Office and the excel executable.

The same process would apply if you noticed trouble with the DOCX file extension or any other filetype you are trying to VIEW/EDIT from FileZilla.

Exchange Online Office 2016 Resource Room Calendar Powershell commands


This is a reference article for tweaking Exchange Online Resources (Meeting Rooms, Equipment, etc).

  • How to show Organizer Name and Subject meeting details on a Resource Calendar (Meeting Room).
    • Fire up a Remote Powershell session
    • First adjust the calendar default permissions:
      Set-MailboxFolderPermission -AccessRights LimitedDetails -Identity “<Room Name>:\calendar” -User default
    • Next set the variables you want to flow into the appointment:
      Set-CalendarProcessing -Identity “Room Name” -AddOrganizerToSubject $true -DeleteComments $false -DeleteSubject $false
    • NOTE: This only applies to new appointments. The old appointments had their details stripped on acceptance of the appointment. You may be able to force an update of those details if you send an update of the appointment to the Meeting room.
    • NOTE 2:
      Get-CalendarProcessing options
      Set-CalendarProcessing optionsInfo for this how to came from: emtunc.org

*Remote Powershell*
Open PS in administrative context
Run: Set-ExecutionPolicy RemoteSigned
Then Run:
$LiveCred = Get-Credential
$Session = New-PSSession -ConfigurationName Microsoft.Exchange-ConnectionUri https://ps.outlook.com/powershell/ -Credential $LiveCred -Authentication Basic -AllowRedirection
Import-PSSession $Session

NOTE: When prompted for credentials, enter your Office 365 admin username/password or one that has admin rights for the tenant.


**Close your PS Session**
Remove-PSSession $Session

Setup new Office 365 mailbox user Active Directory DirSync without Exchange Server On-Prem


Before Server 2008R2, it used to be a pain to edit exchange mail attributes for users without using an exchange server in your environment. ADSI-edit and PowerShell were two tools you could use, but thankfully that has changed since 2012 provides easy access to the Advanced attributes right from the Properties of the user in Active Directory (AD). This how-to assumes you have no on-prem exchange servers anymore and you have DirSync setup properly with all your email users in Office 365.

Quick instructions for setting up a new Office 365 mailbox user in AD:

  • Create the User (in AD)
  • Right-click and go to Properties.
    On the General Tab: Make sure the user’s email address is correct
    On the Account Tab: Make sure the User Logon Name is the first part of their email address (for example first initial +last name). Then make sure the domain is correct. You want the domain to be their email address domain, not that of the local AD domain name if they are different. Then make sure User Logon Name for Pre Windows 2000 is the same as the other logon name, or as close to it as you can be while being unique within the organization.
  • Set the Email Address Properties
  • Click on Attribute Editor tab. Click on Filter and make sure you can see all attributes, not just those with values.
  • Look for these properties and update the values accordingly:
    proxyAddresses: SMTP:primary.email@domain for this user – SMTP needs to be in capitals. This is also where you would enter in any email aliases, just make sure they start with lowercase smtp:
    targetAddress: SMTP:first_part_of_email@tennantname.onmicrosoft.com
    NOTE: Both addresses need to be unique (within your directory). Attribute Editor will let you enter the same for both, but if you do then the user won’t properly replicate to Office 365 when DirSync runs.
  • After that you can wait for another sync to run, or…you can do what I do and force one.
    From the server containing DirSync, open up PowerShell and type “Import-Module DirSync” and enter. Then run Start-ADSyncSyncCycle. The DirSync status window in Office 365 Admin will tell you if it’s synced since you ran the command…shouldn’t take more than a minute.
    NOTE: This does a full sync and will capture all changes. This makes sense for most environments, but if you’re concerned it may not be appropriate for yours, please consult the following document: https://azure.microsoft.com/en-us/documentation/articles/active-directory-aadconnectsync-feature-scheduler/
  • Don’t forget to License the User for Exchange Online in Office 365. Their mailbox should be created soon after you do so and you’re all set.

Other Attributes:

Configure Email Service SMTP on Fortinet FortiGate with Office 365


The three ways you can accomplish this are SMTP Client Submission, Direct Send and SMTP Relay.

The first option requres a mailbox username and password. This option should be considered first because it is the most secure. You authenticate as that user and send email as them. Some obvious caveats: You will need access to a mailbox on Office 365 and when the account password changes you will need to update it on the firewall. Direct Send and SMTP Relay don’t have those requirements.

So if you are choosing between Direct or Relay, you should know that Direct can only send to your own mailboxes. So if some of the mail from your device is going to email addresses other than your own domain’s (could be the case if you need to send reports or VPN authentication emails to people who do not have mailboxes in your org) then you’ll need to use Relay. Just so you know though, Relay requires a static IP.

For a handy chart and full instructions on all three setup variations, please refer to: https://technet.microsoft.com/en-us/library/Dn554323(v=EXCHG.150).aspx

SMTP Relay setup:

  • FortiGate setup:
    System–>Advanced–>Email Service. Turn it on.
    SMTP Server: Your MX Endpoint, example: contoso-com.mail.protection.outlook.com
    Port: 25
    Default Reply To: <any email address for one of your domains, working or dummy>
    Authentication: Off
    Security Mode: STARTTLS
  • Office 365 Connector:
    This is needed to accept email from your firewall. You’ll need the static IP of the firewall and the MX Endpoint.
    In Office 365, Open up Exchange Admin–>Click Mail Flow–>Connectors, create a new connector for mail sent from your organization’s server to Office 365.
    The connector setup will ask you to use one of two methods for verifying the email coming in. The most secure is to use your organization’s security certificate (which you should have installed on the firewall). You can also use the external IP address of the firewall.
  • Recommended setting:
    Domain SPF (TEXT) record: Add to your existing if you have one (multiple SPF records are not supported and will result in email delivery issues), or create one. Format like this: v=spf1 ip4:<Static IP Address> include:spf.protection.outlook.com ~all
    This will ensure your mail doesn’t get marked as SPAM.

To Test: Go to Log & Report–>Alert Email and setup a message to go when you log in and log out of the firewall. Then simply do that and within 5 minutes you should get an alert email