how do I set up multiple projects linked to database in xcel?

[SarahL]

Hello
Using Project and Excel 2003. We have a database in Excel that we hope to
link to Project to pull out multiple gantt charts for mulitple projects -
ideally they will update as the excel data gets updated.

Is this possible - if so could someone please point me in the right
direction.

Cheers

 

[Rod Gill]

You can save a single project in an Excel spreadsheet (via File, save as)
but not many. You can save multiple projects in databases.

You cannot reliably link whole Projects to Excel spreadsheets.

To get multiple projects out of information in one Excel file you will need
to write VBA code to create the projects from Excel.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx