convert project document excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Project Training and help » Convert a project document to Excel.

Convert a project document to Excel.

resolvedResolved · Low Priority · Version 2007

Alistair has attended:
Excel Intermediate course
Project Introduction course

Convert a project document to Excel.

Please remind me how to convert a project document to Excel.

RE: Convert a project document to Excel.

Hi Alistair

Thank you for your question. From the File menu choose Save As... and set the type to Excel Workbook.

A series of dialog boxes will walk you through the settings required to complete the export.

One thing you may want to check is Tools > Options > Security. Make sure that your settings allow Project to prompt you when saving to legacy formats. The export engine generates an Excel document in an older format than 2007. Unless the security setting is set to prompt (or lower) the export will fail.

I hope this helps - do let us know if you have any further quesitons.

Kind regards,
Andrew

Fri 16 Apr 2010: Automatically marked as resolved.


 

MS Project tip:

Typing Links Between Tasks

In the Entry table, use the Precessors column to type in links. Type the previous task's ID to link. To change the link, add FS (Finish-Start), FF (Finish-Finish), and so on, and + duration to add a Lag, or - duration for a Lead time. Example: for task 5, 4FS+1w ... task 4 preceeds task 5, finish to start, with a week lag between.

View all MS Project hints and tips


Server loaded in 0.13 secs.