Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-04-2020, 02:12 AM
badmullah badmullah is offline MS Project and Excel Windows 10 MS Project and Excel Office 2019
Novice
MS Project and Excel
 
Join Date: May 2020
Posts: 3
badmullah is on a distinguished road
Default MS Project and Excel

I have a project that has typical things such as


Task name , start , end , duration ,...etc with a Gantt chart


I also have an Excel spread sheet for this project that I like to combine it with this project.

A project can not like Excel have mutiple sheets (tabs) can it ?
does this mean i have to combine both in one ?

Combining both in one is not gonna look good as both have different columns

Thanks
Reply With Quote
  #2  
Old 01-12-2021, 09:42 AM
miless2111s miless2111s is offline MS Project and Excel Windows 7 32bit MS Project and Excel Office 2007
Novice
 
Join Date: May 2016
Posts: 7
miless2111s is on a distinguished road
Default

you can set up a new table and view in MS project which will have the same columns as your excel which will allow you to copy from the Excel into the Project. However it wouldn't make sense to maintain both Unless the excel is providing an "off plan" method of tracking progress which then needs to be fed back into some summary line in the MSP plan? I sometimes do this when there are a lot of independent tasks which would be a pain to constantly change in MSP; for instance the team may have 200 Procedures to update and have calculated the total time needed to do this and are tracking progress against a 200 row spreadsheet and the Excel sheet kicks out the % complete and start/finish dates to be entered into MSP. The excel tracker provides the burn down charts etc which show if the team is winning or behind on the detailed tasks...
Reply With Quote
Reply

Tags
excel 2007

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import Excel data from MS Project mirabema Project 0 10-07-2020 06:41 AM
Link Project to Excel 50gumbys Project 0 09-21-2020 05:15 PM
Excel Project planner Miv Excel 0 03-01-2011 07:54 AM
MS Project and Excel Advice on my Excel Project woodland81 Excel 4 12-28-2010 01:09 PM
MS Project and Excel Gantt Chart: MS Project vs. Excel Nance Project 2 12-09-2008 01:59 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 12:25 PM.


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