About formatting issues with Project export Excel

1, if prompted with a format problem, this setting:

in tools → options → security, under Legacy format, select the Allow loading files using legacy file format or non-default file format (A) Radio box. You can export Excel tables by repeating steps (1) after saving. 2, about project task level export Excel 1, make good project file. 2. Insert one column at the top: outline level. 3. Create a new Excel file, Copy all of the project contents to an Excel worksheet. 4. In the Excel table, insert a row at the head and select the row. Then click on "Data"--"filter" 5, in the Excel table, filter to select the corresponding outline level, then select the level of Task list data, right-click, "Format Cells"--"align", use "indent" quantity. --Of course, you can also set other formats. Typically 2 levels are set to indent 1, 3 levels are set to indent 26, and each outline level sets a different number of indents. The "level" of project is displayed when the indentation is complete. 3, about the date format of Excel with time, if you do not need time, you can set the date format of Excel, only display the date.

About formatting issues with Project export Excel