Home

Repeating Excel Header Rows

2009-07-27T13:41:54Z

If your worksheet has several pages, it will be useful to have the header row repeat in all the pages. This will improve productivity as the user need not flip to the first page to view the header row columns.

Create a Data View using SP Designer

2009-07-01T17:30:50Z

Using Sharepoint Designer one can create a custom data view that can get data from several sources such as web services, xml data, database queries, and Sharepoint Lists. The view populates the data in real time and hence can be made available to the user's as a web page. This article outlines the method of creating a data view from a SP List.

Create Macro Button in Excel 2007

2009-06-22T12:14:43Z

If you have a macro enabled worksheet and would like the user to have the option to refresh data as required, have a macro button in the worksheet to initiate refresh of the data.. This article is for Excel 2007. If you are interested for Excel 2003. click here

Sharepoint Row Highlight using Behaviors

2009-06-13T23:52:02Z

If you have a long list of items in a Sharepoint list, you may find it convenient to highlight the current row the cursor is on. While there are couple of ways of accomplishing this, this article explains the method of highlighting using Behaviors in Sharepoint Designer. Several tasks can be done using Behaviors, this article highlights one of them.

Macro Button for Excel 2003

2009-06-11T23:08:07Z

If you have a macro enabled worksheet and would like the user to have the option to refresh data as required, have a macro button in the worksheet to initiate refresh of the data.

Creating a custom workflow using SP Designer

2009-06-07T18:32:37Z

Sharepoint has an out of the box workflow that is quite basic and serves well as long as you don't have any conditions to be factored when the workflow is initiated. For example, you may have two departments Finance and IT and depending on the department selected, the approval process or the steps involved in the business process might differ. In such cases, creating a custom workflow using SP Desginer will help.

Using Thickbox for rich User Interface

2009-06-01T22:46:29Z

Thickbox is an User Interface (UI) widget written in JavaScript and built using JQuery library. Thickbox can be used on any page to display images, inline content, iframe content etc. It provides a rich user experience and displays content on the same window.

Using Sharepoint List Default Preview Style

2009-06-01T00:32:06Z

Sharepoint by default displays the list items in a tabular format. The 'title' of the list item is hyperlinked and the user has to click the link to get further details on the item. This method though useful, also involves time as the user has to click each link to get all details. Sharepoint also gives the flexibility to preview list items, though this is not commonly used as it is sort of hidden with other styles.

How to Geocache

2009-06-22T02:12:29Z

Recently I had twitted (no such word?) on twitter "I came across a GPS software for geocaching for windows mobile. It is free and speaks to you as well! http://www.basicgps.co.uk/"

Geocaching involves locating hidden treasures using a GPS enabled device. It is a fun activity with varying levels of difficulty. I installed the software on my HTC Touch Diamond (running Windows Mobile) and in no time was able to setup a geocache location. To find a geocache closer to my location, I use http://www.geocaching.com/ . The basic service is free.

For geocaching the following are the steps:

Install GPS software for geocaching. For my windows mobile, I use ttp://www.basicgps.co.uk/"
Find a geocache location from geocaching.com or similar service. What you need is the latitude and longitude of the geocache
Enter the geocache coordnates onto your mobile phone (in the gps software as per Step 1)
Follow the gps software compass and the voice prompt to find the geocache

The GPS software has also google maps view. But, for me, it was fun just to navigate without the google maps refernce. Geocaching.com has instructions and offers excellent resources, A to Z, on geocaching.

How to add Links and Tabs

2008-11-30T14:01:30Z

The hyperlinks displayed in the Quick Launch region can be modified or new links added. Creating new tabs is also easy with just a few clicks. This article outlines the above: