Category Archives: Office

Office programs keeps asking credentials to connect to SharePoint

Do you recognize this?

You connected a document library to Office, because you want to be able to save Office documents directly to SharePoint, without looking for the right URL. With this ribbon button, you can create a SharePoint location in Word/Excel/etc that you can use as save location. Very usefull.

After some time however, I was going nuts because everytime I had Office documents opened on my machine, about every 15 minutes, I was asked credentials for a customer site I had connected to about a year ago. I didn’t have access to that site anymore, so removing the location thru the ribbon wasn’t possible.

Very annoying when you are in the middle of a training or demosession and every 15 minutes your screen is switched to the login screen. Arghhh!!

Btw: I also had another location Office kept bugging me for. I removed the location in SharePoint but this didn’t help either…

After some #sphelp tweets and a lot of Googling the internet I finally found the solution. Yeah! 🙂

The solution can be found in the registry, at the following key:

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Common\Portal\Link Providers\*Name of link*]

Once you remove the sites for which you are asked credentials, the problem is gone. Puff!!

Synchronize Excel 2010 with SharePoint 2010 List

A couple of days ago, I demonstrated to a group of customers the ability to synchronize Excel 2010 with SharePoint 2010.

In order to synchronize Excel data with SharePoint, you need to convert a range of data into a table. The moment you create the table, Excel will show you an extra button to “Publish and allow Sync” to SharePoint (see screenshot).

Continue reading