Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 11-04-2020, 02:12 AM
badmullah badmullah is offline MS Project and Excel Windows 10 MS Project and Excel Office 2019
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

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

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

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 11:43 AM.

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. is not affiliated with Microsoft