Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-04-2016, 04:58 AM
codeghi codeghi is offline Export Project in Excel Workbook Windows 7 64bit Export Project in Excel Workbook Office 2010 64bit
Advanced Beginner
Export Project in Excel Workbook
 
Join Date: Jan 2010
Posts: 38
codeghi is on a distinguished road
Default Export Project in Excel Workbook

Hi,
I have created an Excel template through "Project Export Wizard" that gives me the list of tasks, with related start and finish dates, project names and resources.
But I don't know how export the summary task: is it possible?
Regards
Codeghi
Reply With Quote
  #2  
Old 09-17-2016, 09:37 AM
JulieS JulieS is offline Export Project in Excel Workbook Windows 7 64bit Export Project in Excel Workbook Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Without having more details I don't know why it wouldn't be exporting all task information. Did you create an export on assignments or tasks? Assignments do not have summary tasks included.
Reply With Quote
  #3  
Old 09-17-2016, 03:53 PM
codeghi codeghi is offline Export Project in Excel Workbook Windows 7 64bit Export Project in Excel Workbook Office 2010 64bit
Advanced Beginner
Export Project in Excel Workbook
 
Join Date: Jan 2010
Posts: 38
codeghi is on a distinguished road
Default

Ciao, I have resolved it!


Just for clarify, I execute these operations:
  1. File->Export->Save Project as File->Microsoft Excel Workbook->Save as
  2. Write a name of Excel file, for example Master.xlsx
  3. Export Wizard->Next->Selected data->Use existing map ->Select Assignment with option Export includes headers
  4. Create a "Map Assignments Data" including Project, Task Summary Name, Task Name, Resource Name, Start, Finish
In this way I can have an Excel file with the desidered columns; if in point 3 I select Tasks instead of Assignment, I cannot visualize the Tasks Summary information.

By

Reply With Quote
  #4  
Old 09-28-2016, 11:32 AM
JulieS JulieS is offline Export Project in Excel Workbook Windows 7 64bit Export Project in Excel Workbook Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Thank you for posting your detailed steps.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export Project in Excel Workbook need vba code export data to closed workbook sheets manilara Excel Programming 1 02-12-2016 08:20 PM
Export Milestones from excel to Project 2010 Manoj Project 1 12-31-2015 02:45 PM
How to add attached excel workbook with hyperlink in the same workbook lynchbro Excel Programming 0 02-24-2015 01:29 PM
PLEASE HELP! How do I export a MS Project CashFlow to an Excel Spreadsheet? CMP.1 Project 9 07-02-2013 01:58 PM
Export Project in Excel Workbook Export Data from Ms project to Ms access using VBA virencm Project 4 02-08-2012 03:18 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft