Dont think thatll do it. It needs to be from task usage, but, unless Im looking at the wrong view, the left side of the screen & the table need to copy separately, and there are three rows of data in the table to each task. There has to be a better way than that degree of manual manipulation?
John
Member for
19 years 11 months
Member for19 years11 months
Submitted by Trevor Rabey on Tue, 2010-01-12 06:30
The report is not there. ive tried setting it up, but for some reason cant produce a task usage pivot table which shows baseline work - actual & scheduled appear no problem.
Member for
24 years 2 months
Member for24 years2 months
Submitted by Mal Leadbetter on Tue, 2010-01-12 05:20
on the tool bar go to < Visual REports> and select the report you require. This will export your info to excel as long as you are using Excel 2003 or later
From my limited use of MSP 2007 so far, I personally think the "Analyse Timescales Data in Excel" macro was better in MSP 2002/03.
Member for
19 years 10 monthsRE: exporting views
Hi Brad
It is not a good idea to give out phone numbers and email addresses on the open forum.
Please use the private message service to exchange this sort of info.
Best regards
Mike Testro
Member for
18 years 4 monthsRE: exporting views
Brad
Dont think thatll do it. It needs to be from task usage, but, unless Im looking at the wrong view, the left side of the screen & the table need to copy separately, and there are three rows of data in the table to each task. There has to be a better way than that degree of manual manipulation?
John
Member for
19 years 11 monthsRE: exporting views
I am pretty sure I can help, but it just takes so much typing to explain it, especially without seeing it.
Is there any chance that you can send me the file so I can see what we are dealing with?
Member for
24 years 2 monthsRE: exporting views
John
As I said, my use of MSP 2007 is limited and I am sure there is someone who may be able to sort this out.
Would the Budget Work Report not give you what you want ?
Sorry I cant be of any more help
Cheers
Member for
18 years 4 monthsRE: exporting views
Mal
The report is not there. ive tried setting it up, but for some reason cant produce a task usage pivot table which shows baseline work - actual & scheduled appear no problem.
Member for
24 years 2 monthsRE: exporting views
John
on the tool bar go to < Visual REports> and select the report you require. This will export your info to excel as long as you are using Excel 2003 or later
From my limited use of MSP 2007 so far, I personally think the "Analyse Timescales Data in Excel" macro was better in MSP 2002/03.
Regards