Display a map for your contacts

If your staff are visiting clients within your SharePoint contacts, you can save them time and effort by displaying a map along with the contact details.  To make life easy for you, here’s a list template that does just that – Contacts with map (Rename the file extension to .stp)

SharePoint Virtual Earth Map

Continue reading


5 Day Weather Forecast WebPart

Being unable to find a sandbox weather forecast webpart that would work in SharePoint online, I decided to make my own using the good old DataViewWebPart:

5 Day Weather SharePoint & Office 365

If you would like to have this on your site you can download the WebPart here – Weather WebPart (Rename the file extension from .doc to .webpart after downloading)

Continue reading

Register a CSS Stylesheet in your masterpage

To make use of any of the supplied CSS on my blog or elsewhere on the internet you may need to know how to add it to your site.  Often its tempting to edit the corev4.css file, but this isn’t encouraged as your changes could be overwritten by a future service pack or could be difficult to undo.  Instead here’s how to register a new CSS style sheet using SharePoint Designer 2010:
Continue reading

Add a document library to favourites in Windows 7

It seems like everyone knows about the Open with Explorer feature, but often overlook its location can be saved to the favourites folder.  Doing so offers the following benefits:

  • Access to documents through My Computer/Explorer
  • Ability to save/open documents direct from MS Office
  • Attach files to emails just as easily as a local/network drive

Adding a document library to your favourites can be done in two easy steps:

  1. Navigate to a document library, click the Open with Explorer button
  2. Within the window that opens, right click Favourites and choose  Add current location to Favourites

SharePoint Windows Explorer

Use Excel 2010 to report on SharePoint lists

A quick win that’s often neglected is to utilise Excel to create reports on SharePoint, here’s how:

  1. Go to the list you’d like to report on and choose Export to Excel
  2. From the Data menu choose Connections then  Properties
  3. Check Refresh data when opening file
  4. Now create a pivot table/chart as you usually would in Excel
  5. Optionally create a named range of the area you would like to display in SharePoint
  6. Save the Excel spreadsheet to a document library within your site
  7. Add an Excel Web Access Web Part to a page
  8. Set the Workbook and Named Range

Note reports won’t update in real time -To update the report, its as easy as pressing the Open in Excel button then saving the spreadsheet.