Category Archives: Tips & tricks

Selection Check Box Disappears from Grouped View SharePoint Slide Library

A SharePoint Slide Library offers an effective way of storing, sharing and managing your PowerPoint presentations. If you publish your PowerPoint presentation to a Slide Library, the slides will be uploaded as individual files which you can edit en even reuse for new PowerPoint presentations.

Now when you have a lot of slides, it seems only logical to group your slides into functional groups and maybe even subgroups. However, when you start grouping your slides, a SharePoint bug shows up (SharePoint 2007 & 2010): the selection check boxes disappear! Continue reading

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

Using calculated column to display SharePoint calendar

Displaying a SharePoint calendar in your intranet/internet site is quite easy. You just add the calendar web part to the page and voilà!

Now, for the most columns in the calendar, this works just fine. To display a Yes for an All Day Event is an option. You don’t like it? Just remove the column from the view. But if you want to use and display All Day Events, the result can be annoying. Check this out:

See that begin and end time of the all day event? It start at 0:00 and ends at 23:59. Now that is pretty ugly to show to your website visitors, isn’t it?

So, what can you do?

Continue reading

Opening and closing tags. Getting around XML rules of XSLT

Working with XSLT in SharePoint can make you come up with some ‘creative’ solutions to a problem.

When using the Content Query WebPart (CQWP), the XML data from a SharePoint list is passed to the CQWP XSLT template node by node. So if you want to render the data in a HTML table, you need to render a <table> tag before the first node with of data and close with a </table> tag after the last node with data. Unfortunately, XSLT doesn’t accept single opening or closing tags. Everything in XSLT must be opened and closed. An opening tag without a closing tag or vice versa is not allowed.

So you need to get creative…

Continue reading