export Project file to xls

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Project
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Resource Usage Report i am trying to print the above report from a resource pool i have set up. it will only show two days on the report? any suggestions? Tag: export Project file to xls Tag: 135123
  - 2
    - Invisible Constraints Hi I found something very strange I have a task which is fixed work. The constraint is asap I use a predecessor so I want that my task starts directly after the predecessor. But it does not It starts two weeks later. Why? I have all tasks on asap all group tasks I checked about constraints etc. but I do not find the solution to this problem. Help please. Kay Tag: export Project file to xls Tag: 135120
  - 3
    - Master Schedule for Operations Has anyone used MS Project for Day to Day operations reflecting field staff? -- Robert Gannon Tag: export Project file to xls Tag: 135118
  - 4
    - Project 2003 XML Question Hi, I am trying to build an XML report which shows the status of summary tasks in my Project. I have built a customer field using Number1 called PriorityTL, which has values: 0 - None 1 - Red 2 - Amber 3 - Green I have assigned these to graphical indicators and that is all working well in my project. What I want to do now is build an XML report which will show 4 tables (None, Red, Amber, Green) and place the tasks inside depending on their PriorityTL. 1. How do I display only Summary Tasks? <xsl:for-each select="Project/Tasks/Task"> <xsl:if test="Summary[.=1]"> This code will show ALL tasks including summary tasks, but I just want the summary tasks, not the detail. 2. How do I display only the "Red" tasks? <xsl:if test="PriorityTL"[.=0/1/2/3]"> doesnt seem to work <xsl:if test="Number1"[.=0/1/2/3]"> doesnt seem to work either I think I probably have both the name (PriorityTL or Number1) wrong and the value (0/1/2/3 vs none, red, amber, green) wrong but I'm not sure. Thanks for any help! Tag: export Project file to xls Tag: 135116
  - 5
    - Baseline Duration Field Not Auto-Calculating I've begun a schedule by inserting baseline duration, start, and finish columns, as I've done before. The problem is that the baseline duration field is not auto-calculating as it normally does. Enter start and finish dates out comes an estimated duration. For some reason, this isn't happening. I don't want to have to manually enter each duration. What am I missing? Your help is appreciated. Tag: export Project file to xls Tag: 135112
  - 6
    - Project 2003 - Must "Check In" a project I was working in Project 2003 pro and it crashed while I had a "Checked Out" Project. When I tried to open the project again from project 2003, the project was still marked as "Checked Out". I am trying to figure out how to reset the file I was working on as now it is only available read only. TIA _-JOE Tag: export Project file to xls Tag: 135104
  - 7
    - a good site for learning Project Hi. I am new to ms Project. Is there a good learning site somewhere. Any suggestions? Thanks in advance Jan Tag: export Project file to xls Tag: 135098
  - 8
    - non working days colour coded? I get how to set up non working days (ie. weekends and holidays)......if I want to keep track of "rain days" lost in the construction indusrty as a seperate colour from the standard weekend grey outs.....is there a way? Tag: export Project file to xls Tag: 135097
  - 9
    - Road Construction Does anyone know where I can find a road construction template or a small sample of one? I've looked through the MS templates but there aren't any that deal with road construction. Thanks! -- John Tag: export Project file to xls Tag: 135096
  - 10
    - Task duration I have a one day task that starts at 8:00 am and ends at 5:00 pm, yet the number in the duration column field shows as .86. When I change the duration column field to 1 day, it makes the end time 9:09 am the next day. If I try to load 8 hours for a resource in this task (the task is a fixed work type task), it says that the resource is over allocated. Can you tell me what might be causing this? Tag: export Project file to xls Tag: 135093
  - 11
    - linked project missing part of file name When linking subprojects into the master project, the first letters which identfy the district where the project is located is being dropped from the name of the subproject. How do I correct this? Tag: export Project file to xls Tag: 135079
  - 12
    - Need to increase the # of characters in a footer in Project. I need to fit a 3 sentence ITAR footer in my Project file, and Project isn't allowing more than a specific number of words or characters. Anyone out there find a way to increase the number of characters that the footer can handle? Thanks! Tag: export Project file to xls Tag: 135067
  - 13
    - hiding tasks within project Is there a way to have tasks that cannot always be seen, I am not refering to hiding subtasks but speciffically not showing some tasks when printing etc. Tag: export Project file to xls Tag: 135058
  - 14
    - Save Microsoft Project 2007 standard as a web page How do you save project to in htm/ web page format? I don't see it under "Save as" as it is in previous versions of MS Project. This is the easiest way to preserve formatting and paste into Excel to share with people who don't have Project but need to provide status/ updates. thanks Tag: export Project file to xls Tag: 135057
  - 15
    - Linking Subtasks from multiple subprojects I currently have 5 subprojects with 1 master schedule...I was wanting to know if it's possible at all to link a task in 3 of the subprojects to one task in the master? Example: I have the following subprojects, each having a development task Subproject 1 Development duration 3/12/08 - 3/14/08 20% Subproject 2 Development duration 3/14/08 - 3/20/08 10% Subproject 3 Development duration 3/17/08 - 3/26/08 5% I would like them all to roll up together in the master... Master Project Development duration 3/12/08 - 3/26/08 12% Is there a way to do this and if so how? Thanks so much!!! Tag: export Project file to xls Tag: 135056
  - 16
    - Actual Work - Distributed in Future While analysing one of our MS Project 2007 plans, I noticed that one of the resources has Actual Work entries for future dates - all the way through April, 2008. This doesn't seem possible and definately isn't legitimate e.g. he hasn't worked those hours yet and they shouldn't be in the plan as actuals - IMHO. We do have a timesheet tool that automatically updates daily actuals onto our plans and my first thought was that this individual processed future timesheets and somehow got them through the approval process and got the hours progressed down to the plan. I ruled this out because this individual is not ahead on his timesheets. Microsoft Project automatically distributes planned work but does it do anything automagically that might explain how future actuals could be present in the plan? I appreciate your help. Mike Kleiman Tag: export Project file to xls Tag: 135055
  - 17
    - Material ressource - usage at the start of task Hi, I have the impression the following is a stupid question but I don't find the solution by myself... I have a ressource with type "material". Let's say this ressource is "steel" and my project is about building a car. The car is built on let's say 3 weeks so I would like the "steel" material usage to change during the 3 weeks: eg: 1 ton used the 1st week, 1 ton used the 2nd week, 1 ton used the 3rd week ==> like it is for a ressource of type "work". Currently, the 3 tons are allocated to the 1st day of the 3 weeks task "build car". I checked the "accrue at" property and it is set to "prorated" so I would expect the 3 tons to be allocated on 3 weeks rather than 1 day. Where am I wrong ?? Thanks in advance Ludo Tag: export Project file to xls Tag: 135033
  - 18
    - Lost tasks I have an old MSProject created with Project 2000. I know there are about 250 listed tasks; however, when I open it, there are only the first nine. When viewing the file with 'notepad', I can see a number of other task names that I know are towards the end of the project (e.g. system test, client acceptance, etc). Is there anyway of recapturing or rebuilding this information? Tag: export Project file to xls Tag: 135028
  - 19
    - Linking dependencies across Subprojects Hi -- I'm trying to link dependencies across subprojects and haven't had any success. For each subproject, the tasks are re-numbered from 1, so I can't refer to a task in another subproject. However, the online help says: "If the projects are interrelated, the project manager can create task dependencies between tasks in different projects. Creating dependencies between projects makes it easier for different project managers to see how work by other project managers affects their schedules. " can anyone help???? if so, thanks in advance! Tag: export Project file to xls Tag: 135014
  - 20
    - Manage Production Resources By Project I need to know what is the best way to measure production support resources on projects --- this would be a way to track outsourced and internal resources --- either through Project Management Software or through Access Database --- thanks! -- flojoe Tag: export Project file to xls Tag: 135013
  - 21
    - Removing a Custom View I created a couple of custom views. How do I remove or hide a view from others? Tag: export Project file to xls Tag: 135011
  - 22
    - Timesheet entry for Admin Projects MS Project seems to add actual work at the rate of planned work for blank cells of PWA Timesheet entries. The added actial work only shows up in Project. It does not add these hours to the Team Members PWA Tasksheet. Normal project files seem to fill in the blank gaps with 0's. Is this normal ? How can stop project from adding actual hours to Admin tasks when the timesheet has blank cells ? Tag: export Project file to xls Tag: 135009
  - 23
    - "Linked Information" prompt when opening a Project file I have Project 2003 Standard SP2 - stand alone. When I open an existing file, I get a prompt stating that my file contains linked information, and asking if I want to re-establish links. I've looked under "Links Between Projects," and no other files are listed on either tab. I haven't linked any tasks or other objects that I am aware of. I'm not sharing resources between projects. What are the ramifications of selecting either option to the prompt? Tag: export Project file to xls Tag: 135002
  - 24
    - problem setting task days & subtask hours In my current project, I have entered all my Tasks, subtasks, and resourses. Here is my problem Some tasks are completed in 1 day (or 8h). These involve multiple subtasks that use different resources. The total time for all subtasks totals 8h. (ex. task--plant tours = 1d, subtasks--freezer, warehouse, processor, packing =2h each) PROBLEM: when i enter hours for subtasks the main task does not total correctly, I get ### or other odd items. Some tasks run 3-4 days, each subtask is equals 1 day. (ex. task--work with drivers 3d, subtask--tom, dick, harry =1d each) PROBLEM: when i enter days for each subtask the main task does not toal correctly 1. How do I correctly enter hours for the subtasks so the main task totals 1d? 2. How do I enter days for subtasks so main tasks total the correct # of days? Tag: export Project file to xls Tag: 135001
  - 25
    - Duplicate Task All, A team member has a duplicate task showing up in EPM in his "Tasks". I have checked the plan in "Resourec Usage" and checked the task in the plan itself to make sure he wasn't assigned twice. I tried to "Hide" the duplicate task in EPM. but I get an error message. Please let me know if you have a suggestion for removing the duplicate task that I have not already tried. Thanks, Scott Tag: export Project file to xls Tag: 134999
- Next
  - 1
    - Default Task Type I have a web development project whose total cost was based on estimated development hours * hourly rarte. The project includes 15 modules, each estimated (hours to complete) separately but with the same hourly rate. Because of the hours estimates should the task type for resources (programmers only) be set to Fixed Work rather than the default Fixed Duration? I'm thinking it makes sense to have the programmer resources be Fixed Work and then insert a 'Work' column in the Gant Chart view to put the est hrs for each module for. Does this sound right? Thanks in advance JR Tag: export Project file to xls Tag: 134997
  - 2
    - MSP07 PDF's Crash? I have a large MSP07 links, rollup and inserted files that I print out with Adobe for a PDF file. When I open the PDF, the file crashes. I've tried making it with a couple of other PDF appications i.e. CutePDF, all with the same results. Has anyone had this sort of problem? Or any suggests how how to fix? Sending the MSP07 file to a normal printer works fine. Steve Tag: export Project file to xls Tag: 134996
  - 3
    - color fill fields Using MS Proj 2003 - tying to add a column (don't know what type I should select) and color code the fields to indicate (subjectively) if my projects are red, yellow or green Tag: export Project file to xls Tag: 134985
  - 4
    - Entering Numbers in Cost Column Can anyone tell me why I cannot enter any numbers into my Schedule. It seems all the column is locked. All other columns are accessible. I am using Project 07 Pro. Thanks Tag: export Project file to xls Tag: 134981
  - 5
    - Project 2007 File corrupt Hello I have a corrupt project 2007 file. It seemed to work just fine for sometime and all of a sudden now i get the following error message when trying to open the file. "The operation cannot be completed because the source file contains invalid project data or the total number of rows would exceed the limit of 1,048,000 rows in a project. Validate the data in the source file, insert fewer rows, delete some rows, or consider dividing your project into subprojects to provide more space for tasks and resources" When i click on ok - i am asked to start it read only but still Project launches a blank file. Any advice would be great on how i can recover my files please Thank you Tag: export Project file to xls Tag: 134975
  - 6
    - Trouble saving a 2003 Project file when adding dependency; open er When working in 2003 Project file after linking tasks or adding dependencies, I receive a file cannot be opened error and am unable to save the changes. Error is: The file cannot be opened; check that the filename and path are correct This file is not exceedingly large less than 856K, there are 405 tasks and subtasks I have tried saving as an MPX format and reopening but it didn't help. What can I do to eliminate this error? Tag: export Project file to xls Tag: 134973
  - 7
    - assign work to resource with definite time hi; i am using MSPS 2007.I assign works to resources but i wanna define the times of working for every resource.for example task A needs 8 hours to complete and it does by resource 1 and resource 2.i wanna resource 1 works 5 hours and resource 2 works 3 hours on this task.I need this method for my timesheets. i dont know how can i define this in MSP. plz help me. thanks. Tag: export Project file to xls Tag: 134966
  - 8
    - retrive a lost document originally saved in word i saved a document 3 weeks ago but all i have are the short-cuts that dont work properly it was an assignment and i sent the original, can i retrive the original document from word I compressed the folder before i sent it but i cant seem to trace the original document just the short cuts. Can the original document be sent back to me as it can not open on my tutors computer. Tag: export Project file to xls Tag: 134965
  - 9
    - not enter actual work in completed task hi I'm using Project Web Access & Project professional 2007. Is there any method for not allow to enter actual work in completed task from resource timesheet. Please help me. Thanks in advance. -- Tag: export Project file to xls Tag: 134964
  - 10
    - =?Utf-8?Q?Kde_najdu_k=C3=B3d_k_otev=C5=99en=C3=AD_instalo?= Kde najdu kÃ³d ke spuÅ¡tÄ?nÃ nainstalovanÃ© aplikace office Word 2007? Tag: export Project file to xls Tag: 134959
  - 11
    - good book for ms project 2003 Please any suggestion for a good book for MS project 2003 . I need to know deep knowledge about MS project 2003 Thanks in advanced Tag: export Project file to xls Tag: 134955
  - 12
    - how do I remove critical split up(23/05/08-05/08/08)6days duratio Tag: export Project file to xls Tag: 134954
  - 13
    - Over allocation symbol I have designed a project three resources are overallocated. It shows overallocation symbol beside two resources and red for the other. My question why it's not showing the over allocation symbol beside all of them. Tag: export Project file to xls Tag: 134953
  - 14
    - Work offline in EPM 2003 Hi, I am using EPM 2003. When I save the schedule offline and consequently work on the schedule offline, I notice that the resource rates have changed. Could you please explain what have caused the different resource rates? Thanks. Tag: export Project file to xls Tag: 134950
  - 15
    - Microsoft offfice project I am trying to insert a poem inside a picture of a flower: how do I insert the same? Tag: export Project file to xls Tag: 134948
  - 16
    - Header Footer Scroll Bar? I just ran into the weirdest thing. I was working on putting information in the Center Footer when for some unexplained reason, I may have hit a sequence of buttons I still so not know which, and a small scroll bar appeared on the righthand side of the window allowing me to move beyond the last line. Has anyone ever seen this, and how do you do this? I cannot find a reference to it anywhere. I am using Project 2007 Pro, no server connection. Tag: export Project file to xls Tag: 134946
  - 17
    - Footer Problem In my Schedule I have to distinct views. One view we call by District has no issues with viewing the footer. Upon trying to type the same information into the second view we call Board Member the Center Text will not stay centered. It is strung out across the top or seems to stay left justified. No matter what I try with carriage returns or alignment seesm to work. Has anyone ever run into this problem? I am using MS Project 2007 Pro, not connected to a server. Tag: export Project file to xls Tag: 134942
  - 18
    - Max. Number of activites in Project 2007 What are the Max. Number of activites in Project 2007 that can be done in a single project.? -- Thank You, Madhu Tag: export Project file to xls Tag: 134922
  - 19
    - Add resource from Outlook Hi, I have done some searching, but haven't come across this problem and resolution for it: If I add a resource from Outlook, I find that the name field includes the contact's e-mail address. I went to Outlook and changed the Display field so that it only includes the contact's name and tried again, but this time *no* e-mail address was imported, although the name field was correct! I'm using Project 2003 with Outlook 2003. Any help would be greatly appreciated! -- Thanks! Dee Tag: export Project file to xls Tag: 134919
  - 20
    - Roll-up Costs within Group I need some help badly. In my schedule I have a column that depicts Cost called Project Budget. Each School is the Summary task with the actual jobs being done as the subtasks. When grouped within the district each school shows the total cost. However, on the District line it shows approximately twice the amount that should be on the line. So in essence it's counting all subtask costs and the total at the school and adding them together. I will send anyone my Project Schedule, this is really critical as this is supposed to go to print today! - Thus I need the help. Thanks, Tag: export Project file to xls Tag: 134918
  - 21
    - Mapping Access-exported Data Columns to Project Columns I know some Access, and thinking about the possibilities of pulling data from a Save As Access DB into reports (rather than cut/past into Excel). Is there a cross-reference of Project Columns to their related Access Table and Columns when exported to Access? -- George H. Foster Orlando, Florida Tag: export Project file to xls Tag: 134910
  - 22
    - Creating Master Schedule with Subschedules Hello, I have just been set up with MS 2007 project server and I am trying to insert my subschedules and want them to flow into what we call a Master Schedule. What is the most accurate way of doing this? Thanks! Tag: export Project file to xls Tag: 134907
  - 23
    - how can i not display non-working time? I would like my gantt chart to simply not display non working time like weekends instead of just greying it out. similarly if i wanted to do a timeline of hours, it shows them as 24 hr periods, i would like to only see the 8 work hours Tag: export Project file to xls Tag: 134906
  - 24
    - protecting the schedule hello, there are a few Project Managers at my work who need to be able to view the schedules. I'm trying to protect the Project Schedule, so that they cannot modify it. I went to Save As -> Tools -> General Options and set passwords and clicked on read only. When I re-open it suggests it to be read only, but when I click "No", it does not require a password and takes me right in, letting me modify everything. What can I do? Thank you Tag: export Project file to xls Tag: 134904
  - 25
    - Assigning a Project Task to Lotus Notes Hi: Does anybody knows how to send a task to a Lotus Notes?..and if that task can be posted directly into the To Do list? Thanks Tag: export Project file to xls Tag: 134903

I want to bring WBS column and task column with all formatting from Project
file to Excel file. So far only able to get WBS column using the "save as"
wizard. What am I missing?
Thanks

Re: export Project file to xls by G�rard

Gérard
Wed Mar 12 09:11:34 CDT 2008

cardn,

Did you created a map ?
What are the fields you insert in that map?

Gérard Ducouret

"cardn" <cardn@discussions.microsoft.com> a écrit dans le message de news:
2731FF75-44C1-4CBE-8CB5-DB8AAD4BDE76@microsoft.com...
>I want to bring WBS column and task column with all formatting from Project
> file to Excel file. So far only able to get WBS column using the "save
> as"
> wizard. What am I missing?
> Thanks

Re: export Project file to xls by John

John
Wed Mar 12 10:25:50 CDT 2008

In article <2731FF75-44C1-4CBE-8CB5-DB8AAD4BDE76@microsoft.com>,
cardn <cardn@discussions.microsoft.com> wrote:

> I want to bring WBS column and task column with all formatting from Project
> file to Excel file. So far only able to get WBS column using the "save as"
> wizard. What am I missing?
> Thanks

cardn,
Just for reference, whatever formatting is applied in Project will NOT
appear in the data exported to Excel, no matter what method you use
(e.g. export map, SQL, VBA, etc.). To replicate formatting, your only
real choice is to re-apply it once the data is in Excel.

John
Project MVP