« 10 pieces of advice to a new blogger | Main | Golden Glow »

Views and Tables in Microsoft Project

There is often some confusion about the difference between a view and a table in Microsoft Project. This should help clarify the difference between the two.

A view consists of a number of potential elements:

A screen (the right side typically, but may include splits. Also includes any special formatting for that screen such as modified barstyles etc.)
A table (the data displayed on the right side
A group (optional)
A filter (typically "All tasks" but may be anything you want)

Different views may access the same table or group or filter or screen but may use a different combination.
Modifying a table will affect all views which use that table.
For this reason, and because I frequently add/remove columns, it is good practice to build a specific table for each view. For example you might build a presentation view which uses a table and filter customized to show only the elements you want to present, or a print view etc.

The data displayed in the table or view does not belong to the table. It is present in the file and is only displayed in the table, so deleting columns in the table does not delete that information. Deleting a row however will delete the information.

This information is the same for all versions of Project, with the exception of Project 98 and earlier which did not have grouping.

RELATED POSTS
  • New Fields in Microsoft Project 2010
  • Project 2010 Tips and Tricks Webcast
  • MS Project Tip - Creating User-defined Filters
  • Microsoft Project Tip - Formulas and the IIF statement
  • Project Server 2010 Technical Requirements
  • Date Math - DateAdd, ProjDateAdd in Microsoft Project
  • Project Server OLAP Views Errors
  • Microsoft Project Undo Levels and Macros
  • Making the move from VBA to VSTO in Microsoft Project
  • Analyze Microsoft Project Resource Usage Data In Excel

  • Comments (1)

    Nico van de Kamp:

    Hello,

    Can you help how to change the fontcolor of MS Project cell. I'm walking through all the to compare the date with some other date. And if it is different I copy one to he other to make it the same. That works fine but I want to change the font color as well like the following example:

    [code]
    Sub SelectTaskRows()
    Dim tskT As Task

    SelectBeginning

    For Each tskT In ActiveProject.Tasks

    'This doesn't work, but just to give a impression what I mean!
    tskT.Start Font Color:=pjRed
    Next tskT

    End Sub
    [/code]

    Nico

    Post a comment

    (Comments are moderated to fight SPAM and will be published after I have a chance to approve them. Thanks for waiting.)

    About

    The previous article is 10 pieces of advice to a new blogger.

    The next article is Golden Glow.

    Current articles are in the main index page and you can find a complete list of articles in the archives.

    Creative Commons License
    This weblog is licensed under a Creative Commons License.
    Powered by
    Movable Type 3.34