Save As dialog box

Export the issue log to Microsoft Excel
Follow these steps to export the issue log to Microsoft Excel:
1. Open the project file.
2. Select File | Save As.
3. Select Microsoft Excel Workbook from the Save As Type menu.

Screenshots by Andy Makar for TechRepublic

Export Wizard - Map Options dialog box

4. When the Export Wizard dialog box appears, click Next twice.

5. Select the New Map radio button and click Next.

Screenshots by Andy Makar for TechRepublic

Export Wizard - Task Mapping dialog box

6. Enter Issue Log for the Worksheet Name.

7. Add the following fields per this figure:
a.tText1
b.tText2
c.tDate1
d.tFlag1
e.tText4
f.tWBS

8. Click the first Text1 row in the To: Excel field and enter the name of the target Excel field per this figure.
g.tText1 : Enter Issue Name
h.tText2: Enter Issue Description
i.tDate1: Enter Target Date
j.tFlag1: Enter Open Issue
k.tText4: Enter Assigned To
l.tWBS: Enter Work Breakdown Structure Id

Screenshots by Andy Makar for TechRepublic

Save Map

9. With the Export Map complete, click Next.
10. Click the Save Map button and enter Issue Log for the map name.
11. Click Finish.

Screenshots by Andy Makar for TechRepublic

Use Existing Map radio button

You have now created a new export map and saved the issue log to Microsoft Excel. Each time you export the map, you do not need to create an export map again; instead in step 5, you will select the Use Existing Map radio button.

Screenshots by Andy Makar for TechRepublic

Map selection

The next step is to select the Issue Log map and click Finish.

Screenshots by Andy Makar for TechRepublic

Uncheck (Blanks)

View the Microsoft Excel issue log
Once the file is exported, open it in Microsoft Excel. You can format the Excel file by expanding the cells and filtering the blank rows.

In Microsoft Excel, follow these steps:
1. Change the width of each column as appropriate.
2. Click the Filter icon.
3. Click the Filter icon in the Issue Description field.
4. Uncheck the (Blanks) check box.
5. Click OK.

Screenshots by Andy Makar for TechRepublic

Issue log in Microsoft Excel

The end result is a filtered issue log that can easily be shared with the project team and with clients using Microsoft Excel. By including the Work Breakdown Structure id in the issue log, you can also cross reference the related issue to the task in your Microsoft Project schedule.

You already know which issue is mapped to a specific task by viewing the Issue Log view in Microsoft Project; the Work Breakdown Structure is used for reference only. Project management artifacts don’t always have to exist as separate documents. Issue management and schedule management can easily be integrated using a custom table, a custom view, and an export map from Microsoft Project. You can create similar views for risk management and change management by following my previous Microsoft Project tutorial’s steps on customization.

Screenshots by Andy Makar for TechRepublic