Save as Excel from Master Project

D

damien

I am trying to export from a master project with about 8 sub-
projects. When I try and export from the master to excel, it does not
include certain text fields. Why? Any work arounds? I need the text
field (name) to use the excel sheet.
 
R

Rod Gill

How are you exporting?

Data lives in the sub-projects, not the master. However, try expanding all
sub-projects and try again

Not all custom fields roll up to the sub-project tasks, so their data is not
available in the master.

For this and other reasons (including no risk of file corruption) I usually
create new masters every week but not linked. This copies all data into the
master and consolidates resource info. The result is much more useful for
reporting purposes and provides a weekly snapshot.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com




damien said:
I am trying to export from a master project with about 8 sub-
projects. When I try and export from the master to excel, it does not
include certain text fields. Why? Any work arounds? I need the text
field (name) to use the excel sheet.

__________ Information from ESET Smart Security, version of virus
signature database 5032 (20100415) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5032 (20100415) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top