TMGR: How to Rebuild a Damaged Team Manager File (159642)

MORE INFORMATION

If a Microsoft Team Manager file is not calculating correctly, and you suspect the file is corrupted, it is possible to salvage information from the file so that you do not have to re-create it from scratch. This is only possible if you can open the file in Team Manager. If Team Manager cannot open the file, you may be able to use Microsoft Access to open the file and retain some information from the various tables. The following process assumes that you are able to open the file in Microsoft Team Manager.

NOTE: You cannot resolve this problem by clicking Save As on the File menu. The new file will retain any problems that the original file contained.

NOTE: The following information will not be carried over to the new file with this process:

• Formatting options
• Work values for people assigned
• Actual Work values for people assigned
• Outlining

NOTE: The following steps will create a new Team Manager file from a damaged Team Manager file. Before you copy and paste information into the new file, both files must display identical fields in all views used. In addition, the start date of the new team file must be the same as the damaged team file.

Set the Start Date of the New File

1. Start Team Manager with the damaged file open (file1).
2. On the Tools menu, click Options. Click the Calculation tab. Note the Schedule Start Date.
3. Start another copy of Team Manager with a blank file (file2).
4. On the Tools menu, click Options. Click the Calculation tab.
5. Set the Schedule Start Date to the date from step 2.

Copy the Resource Information

1. In file1, on the People Tab, switch to Team List view.
2. On the Format menu, click Add/Remove Columns.
3. In the Add/Remove Columns dialog box, click Custom Fields.
4. Make a note of any custom fields that are defined. You will have to duplicate these fields in the new file. Click Close.
5. Remove any columns showing in the Show These Fields list.
6. Select the last field in the Available Fields list.
7. Click Add until all columns are moved to the Show These Fields list.
8. Click OK.
9. Switch to file2 and on the People Tab, switch to Team List view.
10. On the Format menu, click Add/Remove Columns.
11. In the Add/Remove Columns dialog box, click Custom Fields.
12. Re-create the custom fields that were in file1. Make sure the names for the columns and the underlying data types are exactly the same. Click Close.
13. Remove any columns showing in the Show These Fields list.
14. Select the last field in the Available Fields list.
15. Click Add until all columns are moved to the Show These Fields list.
16. Click OK.
17. Select all the rows from file1, and on the Edit menu, click Copy. Make sure that you select the entire row when highlighting the rows.
18. Select the first cell in file2, and then click Paste on the Edit menu.
19. If prompted to Send Team Settings, click No.

If you receive an error, the columns of information may not match exactly in order and type. Check the Add/Remove Columns list in both files to make sure the columns are in the same order, and that all custom fields are of the correct type.

Copy the Task Information

1. In file1, on the Tasks Tab, switch to the Task Organizer view. Verify that the "No Filtering" option is selected under the View/Filtering menu.
2. On the Format menu, click Sheet. In the Format Sheet dialog box, click to clear the People Assigned Rows option, and then click OK.
3. On the Format menu, click Add/Remove Columns.
4. In the Add/Remove Columns dialog box, click Custom Fields.
5. Make a note of the Custom Fields that are defined. You will have to duplicate these in the new file. Click Close.
6. Remove any columns showing in the Show These Fields list.
7. Select the last field in the Available Fields list.
8. Click Add until all columns are moved to the Show These Fields list.
9. Remove the Predecessor and Successor columns from the Show These Fields list.
10. Click OK.
11. Switch to file2 and on the Tasks tab, switch to the Task Organizer view.
12. On the Format menu, click Sheet. Click to clear the People Assigned Rows check box, and then click OK.
13. On the Format menu, click Add/Remove Columns.
14. In the Add/Remove Columns dialog box, click Custom Fields.
15. Re-create the custom fields that were in file1. Make sure the names for the columns and the underlying data types are exactly the same. Click Close.
16. Remove any columns showing in the Show These Fields list.
17. Select the last field in the Available Fields list.
18. Click Add until all columns are moved to the Show These Fields list.
19. Remove the Predecessor and Successor columns from the Show These Fields list.
20. Click OK.
21. Select all the rows from file1, and click Copy on the Edit menu.
22. Select the first cell in file2, and click Paste on the Edit menu.
    
    NOTE: If you receive an error, it is possible that the columns of information do not match exactly in order and type. Check the Add/Remove Columns list in both files to make sure the columns are in the same order and that all custom fields are of the correct type.
23. In file1, add the Predecessor column to the table using the Add/Remove Columns option.
24. Click on the Predecessor column title so that the entire column is selected. On the Edit menu, click Copy.
25. In File2, add the Predecessor column to the table using the Add/Remove Columns option.
26. Select the first cell under the Predecessor column and click Paste on the Edit menu.
    
    This will automatically fill in the Successor column for you.

Saving Any Other Information

The process described in this article will retain your task list and the assignments on the tasks, but the Work values for the assignments will be lost. You can still view the work values for the assignments in the original file by following these steps:

1. Turn on the People Assigned Rows option.
2. In the Task Name field, double-click the Folder icon for a task that has assignments.

NOTE: Double-clicking the Folder icon for a summary task will expand or collapse the subtasks for that summary.

Once you are viewing all assignments, you can print this information, or if your file won't print, copy the information into a spreadsheet program such as Microsoft Excel and print the information from there. (You may want to reduce the number of columns from those used here.) You can then use the printout to update the information in the new file.

If possible in the original file, you can also print out the Actual Work view from the Tasks tab with all the resource assignments showing. This provides you with per period actual data that you can reenter in the new file. In the Actual Work view, you can add columns of information to the Timesheet portion of the View by clicking Add/Remove Timesheet Columns on the Format menu. You can then select the cells in the Timesheet that you want to save, and copy that information into another program. You can then use this as a guide for updating the new file.