Viewing Required Fields in Microsoft Excel and Microsoft Project
If you are adding work items in Microsoft Excel or Microsoft Project, make sure that all required fields are displayed so that you can publish your added work items without having to resolve missing data errors.
Each type of work item for your team project can have different required fields. When you select View Required in the Column Chooser in both Microsoft Excel or Microsoft Project, you receive the required fields for the work items. See the process guidance for your team project for the fields that are required for the work item types in your team project.
To access process guidance for your team project, see.