Ramblings from an IT manager and long time developer.


Excel, OneDrive, and Trusted Locations

if you check the event viewer after trying to open the file from One Drive and get the ‘not a trusted location’ error, there will be an error that begins with Customerization URI: string/your one drive folder. Copy this verbatim into ‘add trusted location’ in your office programs and you are G2G. PITA for sure


Office 365 – Single Sign-On for SharePoint, Skydrive, CRM, etc. via Smart Links

Office 365 – Single Sign-On for SharePoint, Skydrive, CRM, etc. via Smart Links


Synopsis: One of the biggest problems I have seen
with Office 365 is ease in accessibility to all of the Office365
resources.  As pointed out on many of the Microsoft forums, SharePoint,
CRM, Skydrive, etc. do not automatically complete a single-sign on
request when browsing the website.

Problem: When a user
browses for example, the user is
prompted to enter in their email address.  What a user expects is that
they should automatically be logged in and see sharepoint when
navigating to  Additionally, for
whatever reason, users cannot remember the website address to  Instead, they want to do something like

Solution: Create name branded “fancy URLs” that will complete an idp claim to give the user a true SSO experience.



  1. Open up Internet Explorer
  2. Navigate to
    Sign into Office 365
  3. Press F12 to open up the developer tools console (I am running IE
    11, the console looks way different than previous versions of IE)
    Sign into Office 365 - Developer Console
  4. Scroll down and select the icon that looks like a little WiFi antenna
    Sign into Office 365 - Developer Console - Network
  5. Click the green play button
    Sign into Office 365 - Developer Console - Network - Start Capture
  6. Type in your email address as you would to login to sharepoint (
  7. You should be redirected to your ADFS server and inside the network
    console, you should see a link like………………  Copy this link into notepad.
    Office 365 - Federated URL
  8. Remove the extra stuff from the debug console
    Office 365 - Federated URL - Notepad

    Office 365 - Federated URL - Cleaned - Notepad
  9. Remove everything from cbcxt=….. to wa=wsignin1.0
    Office 365 - Federated URL - cbcxt removed
  10. Remove the ct%3D1386214464%26 and bk%3D1386214464%26 parameters
    Office 365 - Federated URL - ct and bk removed
  11. Next, open up another new notepad document named index.html and paste the following text into it
    1. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
      ""><html xmlns=""><head>
      <meta http-equiv=”refresh” content=”0; url= link goes here” /></head>


      Redirect to URL template

  12. Replace link goes here with your new smart link and save the document.
    Redirect to federated URL
  13. Upload the index.html file to one of your your webservers
  14. Create a new A record called pointing to your webserver
  15. Now when a user browses, the user
    will automatically be redirected to your secure ADFS Proxy and
    authenticate automatically.

You will need to repeat the steps above for each of the Office 365
products your company uses.  The federated addresses do change, so you
will have to follow all of the steps over again for each Smart Link you
wish to create.

Here is an official article on creating smart links:


Remove and Re-add product key for Office 2013 and Office 365

Having been on Microsoft Office 365 for a few months now, we started to notice that when users who had activated software on a PC were removed from Office 365, the software would go into “grace period” and would continually notify the new user of the PC that there was a problem. The trouble was I could not figure out how to reassign the software license to the new user. Finally I have found steps that will accomplish this without having to repair/reinstall office.

Open Command Prompt on PC
Open a Command Prompt window, and then take one of the following actions:

  • If you installed the 64-bit version of Office 2013, move to the following folder: C:Program FilesMicrosoft OfficeOffice15
  • If you installed the 32-bit version of Office 2013, move to the following folder: C:Program Files (x86)Microsoft OfficeOffice15

Display the Current License(s)
Type the following command to display the license status. Note the last five characters of any and all license keys that display in the output:

cscript ospp.vbs /dstatus

Remove the License(s)
Now run the following command as many times as needed to remove all of the license keys you noted from the previous step.

cscript ospp.vbs /unpkey:[LAST 5 numbers of existing product key]

Restart the Computer

Once the remove commands are successfull, close the command prompt and restart the PC.

Reactivate MS Office 2013 with New Account

Launch one of the MS Office 2013 applications (I like to use Word). The application should prompt you to reactivate the by providing your sign-on ID. Enter in the new user’s credentials and the software will now be licensed under their ID.


Manually enable Appear Offline in Lync 2013 (or Skype for Business 2016) via Registry

Lync 2013, just as with previous releases, allows the ability to Appear Offline. And just as with previous releases, you can enable this functionality in the Lync Client Policies. For information on how Lync Client Policies work, see my post here. To enable Appear Offline through Client Policy against the Global Policy, use the following command:

Get-CSClientPolicy | Set-CSClientPolicy -EnableAppearOffline $true

This will require a Lync 2013 client restart.

As an Administrator, you may not want to make this change to a Client Policy as the goal of Lync is to promote collaboration, not inhibit it by having users Appear Offline and hide from other users. At the same time, you may want to enable it for a user or two at request and won’t want to have to bother providing this small group of users their own Client Policy. Lync 2010 provided the ability to do that via registry key. Mike Pfeiffer provides a great article on Lync 2010 for setting the Lync 2010 registry key to manually enable Appear Offline in Lync 2010. You can see his article here.

The goal of this article is to show how to do the same in Lync 2013. Because Lync 2013 is now a part of Office 2013, Lync 2013 registry items are now under the Office 2013 registry section (Office 15.0). There are two ways to set this registry:

  1. Cmd.exe
  2. Regedit.exe

Using Cmd.exe

The type the following command:

Office 2013

Reg Add "HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Office\15.0\Lync" /V "EnableAppearOffline" /D 1 /T REG_DWORD /F

Office 2016

Reg Add "HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Office\16.0\Lync" /V "EnableAppearOffline" /D 1 /T REG_DWORD /F

Using Regedit.exe

  1. Start regedit.exe
  2. In Registry Editor, expand HKEY_LOCAL_MACHINE, expand Software, expand Policies, expand Microsoft, expand Office, expand 15.0, expand Lync
  3. Right-click the Lync registry key, point to New, and then click DWORD (32-bit) Value
  4. After the new value is created, type EnableAppearOffline to rename the value.
  5. Double-click the new EnableAppearOffline registry value.
  6. After the new value is created, type EnableAppearOffline to rename the value.
  7. Double-click the new EnableAppearOffline registry value.
  8. In the Edit DWORD (32-bit) Value dialog box, type 1 in the Value data box, and then click OK.


Google Calendar Sync upgrades Outlook 2010 support

Repost from here

Making sure that your calendar is available to you whenever and wherever you need it is important. That’s why Google Calendar works with a number of desktop applications and mobile devices including iCal, iPhone and iPad, Blackberry, Android, Nokia/Symbian, and Windows Mobile phones. Google Calendar Sync for Outlook is also available, but one thing was missing — until now.

Google Calendar Sync now supports Outlook 2010 — our top feature request. Outlook 2010 comes in 32-bit and 64-bit versions. To start syncing your calendar with Outlook 2010, download Google Calendar Sync version (google direct download).  Once you install it, a Settings window will appear. Enter your account’s email address and password, choose your sync option and sync frequency, and you’re done! (Note: If you’re already using Google Calendar Sync, you’ll still need to download and install this new version in order to be able to sync with Outlook 2010. If you need help, take a look at our getting started guide.)



Outlook Add-Ins and Tools

Outlook Contact Manager
General Outlook Tools (SimlyFile, EZDetech, etc)

Compress Attachments in Outlook


Using Office 2010 for the “Get It Done” methodology


Outlook Setup

OneNote Setup

Organizing your Outlook inbox

Organizing your OneNote Inbox

Collection of Information


User Adoption: Educate the End User Community (

Start Your Engines!User Adoption: Educate the User Community on the Differences between Blogs, Wikis, RSS Feeds, Discussions and SharePoint Lists


The most powerful feature of SharePoint is its ability to socialize information, to offer the people in your company an easy to use collaboration environment that will provide them the ability to publish information for others to consume. The ease with which users publish information with SharePoint often overshadows the need for your users to understand exactly _what_ SharePoint capability to use. Believe it or not, your users are probably confused as to just which capability of SharePoint to utilize when they want to share information.

In a recent discussion I had with several end users, they were most confused regarding the differences between SharePoint Blogs, SharePoint Wikis, discussion boards and the myriad of available SharePoint List options. And RSS feeds? Forget about it. This may be one of the most confusing capabilities to end users of all.

Here’s how I describe each of the capabilities mentioned above so that users can compare and contrast them to determine which to use for their particular situation:

SharePoint Blogs

Blogs are a ‘one-to-many’ conversation. This means that Blogs are generally best used when one person who’s a Subject Matter Expert (SME) produces blog postings to share what they know with a larger audience. Blogs can also be written by a team of SME’s so that the responsibility to write postings fall to a larger number of people and so that there are different voices offered to the readers (much like this blog, One of the secrets to user adoption of blogging in your environment is to educate your people on the following two things: 1) the importance of sharing information to increase the level of collaboration within your company and, 2) the importance of your users providing feedback to blog postings.

I was with a client recently that wanted to promote blogging but people were not embracing the idea. I was told the story of a wicked smart manager that had started blogging but stopped after only three postings (sound familiar?).

One of the manager’s direct reports asked me, “How can I encourage her to start blogging again and what to say to her?” I told her not to talk with her manager but, instead, talk with a minimum of 5 members of her team, tell them to go out to their manager’s blog and each write a response to any of the blog postings. I told her it was very important to have them write honest, thoughtful responses to the postings provided and to not be insincere or fake.

Two days later, with the responses having been written, the manager reinitiated her blogging without anyone even talking with her directly. The importance of feedback to an individual’s blog postings should not to be underestimated (on that note, why not write a response to this posting after you finish reading it? : )

Start Your Engines!Start Your Engines! Tell your users to identify a topic that they are the most knowledgeable about or that they are most passionate about. If they can’t come up with anything, get their manager to tell them what _they_ think is their strongest area of knowledge. Everyone likes to be flattered by hearing what others think they know the most about. Then show them how to create a SharePoint Blog and post to it.

The Blogging interface in SharePoint is not the most user friendly thing, so show them how to use the Word 2007 blogging capabilities or have them download the free Live Writer application from Microsoft. (Btw, Live Writer is awesome! If you haven’t tried it, I highly recommend it.)

SharePoint Wikis

Wikis are a ‘many-to-many’ publishing mechanism where all members of a team are equal and are asked to add their own knowledge and background to the information being presented. Wiki’s allow for free-form information and are infinitely malleable with regards to format and information presentation.

My experience is that your users will find Wiki’s wildly beneficial once they see some examples of a well-formatted, well-written Wiki. When talking to users about Wiki’s I generally take people to and show them the Wiki entry for ‘Baseball’. Showing users that pictures, hyperlinks, well-written narrative and tabular information can be easily broken down by section header has an immediate impact on people.

They seem to ‘get it’ really quickly once they see examples of how Wiki’s can be used. While SharePoint Wiki’s are as powerful as we would like for them to be, it is simply more important for you to get your users used to publishing information for people to read that it is to focus on the features of the SharePoint Wiki.

I was told the story of an extreme technophobe that pushed back on all technology changes and enhancements, including Wiki’s. Once someone showed her how to use the tool she said, “That’s it!? Heck, even I can do that!” You would be surprised at how many people will start using the more advanced SharePoint capabilities once you sell them on how easy it is to use a Wiki.

Start Your Engines!Start Your Engines! Tell Human Resources or a team of people in your department that new employees are frequently confused by the acronyms and abbreviations that your company uses. Ask them to collaborate on a Wiki that will describe in detail what each of the acronyms mean, who is a key person in your company that knows a lot about the topic the acronym refers to and describe some examples where the acronym applies in the practice of your business. Call the Wiki something cool like “Jargon Watch” or “C.A.R.L.” (Comprehensive Acronym Resource for Lingo). Now, tell them how important it is to keep it updated!

SharePoint RSS Feeds

Most techies know that RSS stands for ‘Real Simple Syndication’. What a horrible name for such a great technology capability! Users don’t understand, and honestly don’t care, what RSS stands for because they see it as just another technology acronym that reinforces the moat around the ivory tower of the IS Department. Instead, I call them ‘newsfeeds’. I also tell people that RSS is like a radio station’s broadcasting tower.

The radio station broadcasts a signal and your radio receives it. While you can listen to the broadcast, you can’t talk back to the radio station through your radio because you can only receive the signal the radio tower is sending. I show people the RSS icon at the bottom of the Yahoo! News site so they understand that this is an internet technology, not a SharePoint technology. I show them how to add the RSS Web Part to the SharePoint page and how to put an RSS feed from Yahoo! News. Then I tell them that every SharePoint list that they create has an RSS feed associated with it so that others can be kept up to date with regards to what’s happening on the SharePoint site without even visiting SharePoint or getting alerts. Users dig RSS if you make it applicable to them.

As I say in my SharePoint Training classes, “What’s everyone’s favorite Radio Station? WII-FM, of course!” (WII-FM stands for ‘What’s In It For Me?’)

Start Your Engines!Start Your Engines! Identify two or three of your company’s competitors and perform a search in Yahoo! News with the competitor’s name. Capture the URL associated with the RSS feed for the competitor and paste that into the RSS Web Part in SharePoint on one of your main pages that people see frequently. Limit the number of news stories to 2 or 3 so that the page load times won’t increase dramatically. Enjoy! (I find that Google RSS feeds don’t display as nicely and expand as nicely in the SP RSS Web Part as the Yahoo! Feeds).

Discussion Groups

Discussions are a great way to allow people to post questions for others to read and respond to. This is great for shift workers that rarely see their co-workers and for Q&A discussions. (If you have been successful at getting people talking using discussion groups, share your experience with the rest of us….please).

Discussion groups work best when you use them to build a knowledge-base of Q&A with regards to a particular facet of your business. While people generally have a lot of questions, the people that have the answers don’t generally peruse the questions and provide insightful, thoughtful answers to them.

Quite simply, there is just too much to do and too few people to do it.

One of the secrets to making discussion groups successful within your company is to limit a discussion group to a specific topic where all postings have a similar theme or focus. Discussion groups that are too broad and are not focused on specifics generally won’t be successful.

Start Your Engines!Start Your Engines! Open up a discussion group where people can ask questions about SharePoint and how others are using it in your company. Allow people to post any and all questions related to SharePoint but police the questions to ensure that questions about PeopleSoft, Oracle or the best flat screen TV on the market are kept out of the discussion threads.

Foster a community of users and allow your user community to begin to answer the questions people are posting. This helps to provide an “I was one where you are now” feeling to the education which helps people to absorb the information without feeling like they are asking a silly question.

SharePoint Lists

Lists are a great way to capture and present ‘active’ content on your SharePoint site. This is information that you update regularly and share with others so that they have the ability to use it to make business decisions. After all, that’s probably one of the reasons you deployed SharePoint in the first place, isn’t it? To inform others of information they don’t know?

SharePoint lists allow you to sort information by the column header, filter the information being presented and present information in a read-only format so that people can consume the information but not necessarily contribute to it. Lists also allow the user to sign up for alerts to be notified when things change.

Lists are very powerful and very confusing to your end users. They are infinitely malleable, which is their greatest power and their greatest weakness. The power comes in that the list can display information and capture information in fields (called ‘columns’ in SharePoint) while the weakness manifests itself in the myriad of field _types_ that are available in SharePoint.

Educate your users that if a pre-defined SharePoint list doesn’t contain a column that will capture the information they need that they can just create the list. Tell them how each _type_ of column will benefit them and provide examples on how and why they would use each column type.

Start Your Engines!Start Your Engines! Tell your team that you want them to create a SharePoint contact list for their team members to use to share business contacts. Show them how to delete the “Full Name” column from the list and add it back as a ‘calculated column’. Then, concatenate the first and last name columns in the calculated column called “Full Name” and walk them through three or four other column types.

One of the columns that users get most excited about it the ‘Lookup’ column that pulls information from an existing list. For your more advanced users, provide them the information contained in Dessie Lunsford’s excellent series on calculated columns and really blow their minds with what they can do!


There is no silver bullet for increased SharePoint user adoption. It takes 2 parts education, 1 part toughing-it-out, 2 parts patience and 4 parts dedication to answering dozens and dozens of questions. A great place to focus on educating them on when to use each of the specific SharePoint capabilities to move beyond the how.

Next week, I’ll write about creating a ‘Collaboration Café Meeting Place’ for your users that will help grow your SharePoint User Community.

Author: Lee Reed
ThoughtBridge, Atlanta, GA




Two Great eBooks on using the Calculated Column in SharePoint author just recently posted two completed eBooks (Part 1 and 2) for taming the Calculated column in SharePoint.
I highly recommend taking a look at them…


Microsoft Whitepaper on Document Management in SharePoint


Microsoft delivers an integrated solution that extends document management to all employees. By recognizing that a document’s lifecycle begins the moment it is created and does not end until it is destroyed, organizations can achieve wide adoption and enforcement of enterprise standards, resulting in decreased management costs and reduced corporate risk.

Office SharePoint Server 2007 Document Management Whitepaper