Subscribe via RSS Feed Connect with me on LinkedIn

Task List Export – Access, Project and Visio

[ 6 ] June 7, 2010 |

It always amazes me how many little tid bits are hiding inside of SharePoint 2010 and this is another that I found when working with a task list.

If you have a task list you now have the option to export the list to the following formats: Access, Visio and Microsoft Project.

To do this simply go to the task list that you are interested in, click on list and then from the ‘Connect and Export’ group choose on one of the following options:

Export Task List Options

Create Visio Diagram

This will create for you a really cool data driven PivotDiagram consisting of three sheets: Task Status, Workload Distribution and Incomplete Tasks by Assigned.
You can then mess around with this but remember that Visio will not push your changes back to SharePoint. It does however allow you to see your tasks in a unique way

Visio 2010 Tasks

Open with Access

First of all you will get this prompt below which will ask you if you want to link the data or not, so you can have a two way sync between Access and SharePoint.

Access options when opening a task list

From here you can now play around with the list using Access 2010 and all the goodies that it offers like below:

Access 2010 Export

Access 2010 Export

Open Schedule

In this option you can open up the task list in Microsoft Project and play around with it in there which actually contains a few options that are quite useful, for starters you can now change tasks within Project 2010 and then have them updated in SharePoint 2010.

Project 2010 Export

Project 2010 Export

So here we have 3 little options that we can leverage out of the box in SharePoint 2010, who knows what else we will find :)

Tags: , ,

Category: General

About Michal Pisarek: Michal Pisarek is the founder of Dynamic Owl Consulting and a Microsoft SharePoint MVP. View author profile.

Comments (6)

Trackback URL | Comments RSS Feed

  1. niko1312 says:

    How can I enable those options if I have them disabled on my SP2010
    I have SP2010, Project Server 2010, and TFS2010 installed

  2. andrew says:

    What version of project is required for “open the schedule” feature. Project Standard? Professional? Ultimate? I have standard and this feature does not work.

  3. Hey Andrew,
    You need to be using Project Professional.

  4. Tom says:

    Hi there,

    I am trying to enable the “Create Visio Diagram” button in a custom list. Any ideas in this direction? I am anticipating custom coding, but I am not sure where to start. Any help will be greately appreciated. Thanks a bunch.

    I have posted the question in as well:

  5. Carlos Lone says:

    Will the “open schedule” button work with Project 2007? which version should I use ?

Leave a Reply

If you want a picture to show with your comment, go get a Gravatar.