• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

danblee.com

Tutorials & Knowledge Base Articles for System Administrators who wear many, many hats.

  • Home
  • About
  • Ask Me
  • DBLHost.com
You are here: Home / Archives for Microsoft Office

Microsoft Office

Calendar sharing is not available with the following entries because of permission settings on your network.

December 2, 2013 by Dan B. Lee Leave a Comment

You're going to get this error in later versions of Exchange because you allowed the TO field to auto-complete instead of choosing the name from the GAL. Clear out the TO field and only add people to the field using entries from the GAL. … [Read more...] about Calendar sharing is not available with the following entries because of permission settings on your network.

Filed Under: Exchange 2010, Exchange 2013, Microsoft Office, Microsoft Outlook, Windows Server Tagged With: Exchange, GAL, Permissions

Exchange 2013: Adding An Outlook Public Calendar to the GAL / OAB

December 2, 2013 by Dan B. Lee Leave a Comment

No chit chat here, just a quick explanation of how to add a Public Folder Calendar to your GAL in Exchange 2013. The quick answer: Mail Enable the Public Folder item. Once the Public Folder item is mail enabled you'll be able to see it in the GAL. Here's how to mail enable an item using the GUI: Head to Public Folders > Public Folder > Drill Down to the Public Folder Item (Contacts & Calendars are most popular) and highlight the item. On the right hand side you'll see an option … [Read more...] about Exchange 2013: Adding An Outlook Public Calendar to the GAL / OAB

Filed Under: Exchange 2013, Microsoft Outlook, Uncategorized Tagged With: Exchange, GAL, Public Folders

Display Modified Date of Excel File

December 19, 2012 by Dan B. Lee 11 Comments

In my last post about how to append or prepend text to data in a cell, Larry asked how one might be able to display the modified date of an excel file. This tutorial will explain the most efficient way to display the modified date of the file you are working on in a cell. Get Ready For Macros Getting right to it, the modified date of an excel file exists, but it isn't accessible via any of the functions that Excel has created for us. Instead, we'll create our own function in the Visual Basic … [Read more...] about Display Modified Date of Excel File

Filed Under: Microsoft Excel Tagged With: excel functions, macros, public functions

Append or prepend text to the current date in MS Excel

December 18, 2012 by Dan B. Lee 4 Comments

Appending or prepending something is called concatenating in Excel. Concatenating is a big word for combining things in one cell. You could be trying to combine text and data, or two types of data, or two cells of text\data together into one cell. We'll be discussing how to concatenate text with date data. How to add text before or after a function in the same cell: Let's produce today's date in an cell. For that, we'll use the following function: =TODAY() Alone, this will produce … [Read more...] about Append or prepend text to the current date in MS Excel

Filed Under: Microsoft Excel, Microsoft Office Tagged With: Concatenate, Date and Time, Excel, Functions

Recover a Mailbox in Exchange 2010

September 20, 2012 by Dan B. Lee 7 Comments

Here are some things you'll need, for sure, before you get started: Access to the Exchange Server A backup of the exchange database (.edb) file and its logs The name of the mailbox you wish to recover and a second mailbox in case you'd like to copy data from the recovered mailbox to a random mailbox so you don't overwrite anything Here are the steps to the recovery: Add the Exchange Database to the Exchange Server as a "Recovery Database" Correct an issues with the database, … [Read more...] about Recover a Mailbox in Exchange 2010

Filed Under: Exchange 2010, Microsoft Outlook, Windows Server, Windows Server 2008 R2 Tagged With: Exchange Databases, Mailbox Recovery, Microsoft Exchange Server 2010, MS Exchange, PowerShell, Recovery Storage Group, Windows Server 2008 R2

MS Office Spell Checker Not Working

December 7, 2011 by Dan B. Lee 2 Comments

No red underline while typing words incorrectly? If you upgraded Outlook to version 2010 but left the rest of your Office products at 2007, you may not be getting red underlines when you type words incorrectly in Outlook. Here's the easy, easy fix for this: Find the winword.exe file for Office 2007, located by default in C:\Program Files\Microsoft Office\Office12 (C:\Program Files (x86)\Microsoft Office\Office12 if you’re using 64bit). Copy and Paste winword.exe into Office 2010's … [Read more...] about MS Office Spell Checker Not Working

Filed Under: Microsoft Office, Microsoft Outlook, Microsoft Word Tagged With: MS Office, MS Word, Spell Checker

« Previous Page

Primary Sidebar

Categories

  • Active Directory
    • Group Policy
  • Adobe Photoshop
  • Browsers
    • Chrome
  • Cloud Based Technology
    • Citrix XenApp
  • ConnectWise
    • LabTech
  • Dell
  • Internet Service Providers (ISPs)
  • iPhone
  • Linux
    • CentOS
    • OpenVPN
    • SaltStack
    • Ubuntu
  • Microsoft Office
    • Lync
    • Microsoft Excel
    • Microsoft Outlook
    • Microsoft Word
  • Microsoft Windows
    • Active Directory
    • PowerShell
    • Windows 7
    • Windows 8 Preview & Release
  • Networks
  • News
  • Off Topic
  • Office 365
  • Peripherals
    • Monitors
  • Printers
    • Local Printers
    • Network Printers
  • Programming
    • Python
  • Riverbed
  • Security
  • Sharepoint
  • Social Media
  • Splunk
  • Storage
  • Switching & Routing
    • Cisco
    • Fortinet
  • Technology Culture
    • Opinion
  • Uncategorized
  • Virtualization
    • VEEAM
    • VMware
  • WAMP
  • Web Hosting
    • WHMCS
  • Website Design
  • Windows Server
    • Exchange 2003
    • Exchange 2010
    • Exchange 2013
    • Microsoft SQL
    • Windows Server 2003
    • Windows Server 2008 R2
    • Windows Server 2012
  • WordPress

Footer

Recent Activity

  • pings on Xerox Phaser 3635MFP Default Admin Username and Password
  • Xerox Phaser 3635MFP Default Admin Username and Password — danblee.com on About Dan B. Lee
  • Estudio Login | LOGINEGG on Toshiba E-Studio Default Administrator Username and Password
  • Estudio Login | LOGINSPENT on Toshiba E-Studio Default Administrator Username and Password
  • Estudio Login | CHARTLOGIN on Toshiba E-Studio Default Administrator Username and Password

Dan Lee

Dan B. Lee works at SyApps, LLC., a Managed Hosting Solutions Firm, as a Senior Network Engineer. Dan has a decade of IT experience and specializes in a number of different disciplines including Virtualization, Web Site Hosting and Design, Network Security, Data Center Architecture, Local and Remote Server Hosting, and Backup & DRS Solutions. Read More…

Links

  • Home
  • About Dan B. Lee
  • Ask Me
  • Privacy Policy

Copyright © 2021 · Genesis Child Theme on Genesis Framework · WordPress · Log in