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

Mal

The report is not there. i’ve tried setting it up, but for some reason can’t produce a task usage pivot table which shows baseline work - actual & scheduled appear no problem.

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 can’t be of any more help

Cheers

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?

Brad
Don’t think that’ll do it. It needs to be from task usage, but, unless I’m 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

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