exporting views

J
John Banks 👤 Member for 18 years 11 months
M
Mike Testro 👤 Member for 20 years 5 months

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

J
John Banks 👤 Member for 18 years 11 months

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

T
Trevor Rabey 👤 Member for 20 years 6 months

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?

M
Mal Leadbetter 👤 Member for 24 years 9 months

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


J
John Banks 👤 Member for 18 years 11 months

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.

M
Mal Leadbetter 👤 Member for 24 years 9 months

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

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts