Troubleshooting

 < Day Day Up > 

Making Column Headers Appear When Pasting

graphics/note_icon.jpg

I've copied and pasted both a table and timephased data from the Task Usage view into an Excel spreadsheet, but I can't get the column headers to appear automatically. What's wrong?

When you copy data from a Project view and then you do a standard Paste operation, the column headers from the table or timephased grid do not appear automatically. If you want to see the column headers after the paste operation, you must type them. If you want the column headers to appear automatically, you should consider doing a Paste Special and then pasting either a linked or an unlinked Microsoft Project object.

Efficiently Customizing a Table

Before I paste data into Project from another application, I want to modify the columns in a standard table, but I don't want to permanently change the layout of the table. How can I do this?

The best way to make changes in a standard table is to make a copy of the table and customize the copy. The quickest way to do that is as follows :

  1. Right-click over the gray-colored blank space above the row numbers (the Select All button) to display the Tables shortcut menu. Select More Tables to display the More Tables dialog box. The table you are viewing is selected.

  2. Click the Copy button, and Project opens the Table Definition dialog box, with a copy of the table you were viewing.

  3. Before modifying the table, give it a unique new name to distinguish it from the standard tables.

  4. Make changes in the columns to be included in the table, and then click OK to save the table definition.

  5. If you want to use this new table with other projects, click the Organizer button, copy the new table to your GLOBAL.MPT file, and then click Close.

  6. In the More Tables dialog box, click Apply to view the new table design.

Restoring Standard Tables That Have Been Customized

I accidentally customized a standard table without making a copy of it first. How can I restore the standard table and keep the customized version as a new table?

You need to do three things : Rename the customized version of the table, apply the renamed table to the view you designed it for, and copy the standard version of the table from the Global template into the project. The quickest way to rename the table and apply it to its intended view is to follow these steps:

  1. Display the view that contains the customized table.

  2. Right-click the gray blank space above the row numbers (the Select All button) to display the Table shortcut menu.

  3. Select More Tables to display the More Tables dialog box. The table name is highlighted.

  4. Click the Copy button to have Project create a copy of the customized table in the Table Definition dialog box.

  5. Rename the table with a unique new name to distinguish it from the standard tables.

  6. Select the Show In Menu check box if you want the table to appear on the Table menu. Don't forget to delete the ampersand symbol (&) from the table name so that this copy does not have the same hotkey on the menu as the original table.

    For more details about defining tables, see "Using and Creating Tables," p. 840 .


  7. Click the OK button to save the copy and return to the More Tables dialog box.

  8. If you want to use this new table with other projects, click the Organizer button, copy the new table to your GLOBAL.MPT file, and then click Close.

  9. Click the Apply button to display the new table in the active view.

To restore the original version of the standard table, follow these steps:

  1. Be sure that there is no view open that contains the table name you plan to copy from the Global template.

  2. Display the Organizer by choosing Tools, Organizer.

  3. Select the Tables tab.

  4. Select the name of the standard table that you want to restore from the list on the left (the list of tables in GLOBAL.MPT ).

  5. Click the Copy button to copy the table to the list of tables on the right (the list for the active project).

  6. When Project tells you that the table already exists in the active project, click Yes to replace the table with the standard version from the template.

  7. Click Close to close the Organizer.

 < Day Day Up > 


Special Edition Using Microsoft Office Project 2003
Special Edition Using Microsoft Office Project 2003
ISBN: 0789730723
EAN: 2147483647
Year: 2004
Pages: 283
Authors: Tim Pyron

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net