Microsoft Office Tutorials and References
In Depth Information
Opening other file formats in Project
but accounting for basic scheduling issues, such as distinguishing between working and
nonworking time, is impractical in Excel.
When saving data to or opening data from other formats, Project uses maps (also called
import/export maps or data maps ) that specify the exact data to import or export and how
to structure it. You use import/export maps to specify how you want individual fields in the
source program’s file to correspond to individual fields in the destination program’s file.
After you set up an import/export map, you can use it over and over again.
TIP If you have Excel installed on your computer, open the workbook named Sample Task
List in the Chapter20 folder. This is a file you will import into Project. The important things
to note about the workbook are the names and order of the columns, the presence of a
header row (the labels at the top of the columns), and that the data is in a worksheet named
“Tasks.” When you are finished with the workbook, close it without saving the changes.
The scenario: At Lucerne Publishing, a colleague has sent you an Excel workbook that
contains her recommended tasks and durations of activities for some work that Lucerne
Publishing might do in the future. You’d like to import this data into Project.
In this exercise, you open an Excel workbook in Project and set up an import/export map to
control how the Excel data is imported into Project.
IMPORTANT Project 2013 has a security setting that might prevent you from opening files
from previous versions of Project or files in other nondefault formats. You’ll change this setting to
complete the following activity and then restore it to its original setting.
In Project, on the File tab, click Options .
The Project Options dialog box appears.
Click Trust Center .
Click Trust Center Settings .
The Trust Center dialog box appears.
Click Legacy Formats .
Under Legacy Formats , click Prompt when loading files with legacy or non-default
file format .