Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-26-2014, 12:29 AM
khawar khawar is offline Multiple projects in a sheet Windows XP Multiple projects in a sheet Office 2007
Novice
Multiple projects in a sheet
 
Join Date: Jun 2014
Posts: 5
khawar is on a distinguished road
Default Multiple projects in a sheet

I want to plan multiple projects in one sheet, so that I could use same resource for different projects. But in this case I can not see the critical path and if I plan different projects in separate sheet using shared resources option, then I can not see the impact of any delay on other projects untill I open and see all project files. Currently I am working on more then 50 projects at the same time
Reply With Quote
  #2  
Old 06-26-2014, 12:40 AM
khawar khawar is offline Multiple projects in a sheet Windows XP Multiple projects in a sheet Office 2007
Novice
Multiple projects in a sheet
 
Join Date: Jun 2014
Posts: 5
khawar is on a distinguished road
Default

added
how can task/resource be linked with other, if plan different projects in separate sheet
Reply With Quote
  #3  
Old 06-26-2014, 03:31 AM
marif300 marif300 is offline Multiple projects in a sheet Windows XP Multiple projects in a sheet Office 2007
Advanced Beginner
 
Join Date: Jun 2014
Location: Pakistan
Posts: 38
marif300 is on a distinguished road
Default

Select both tasks and then click on (link task) button or press Ctrl+F2, moreover this change will automatically reflect on individual plans also.
Reply With Quote
  #4  
Old 06-26-2014, 06:32 AM
JulieS JulieS is offline Multiple projects in a sheet Windows 7 64bit Multiple projects in a sheet Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You have a couple of options:
When keeping all tasks in one project, you can view individual network critical paths through Tools > Options, Calculation - show multiple critical paths.

You may create a resource pool file
http://office.microsoft.com/en-us/pr...010214871.aspx

And then create a master project from the pool to link tasks across project files.
Reply With Quote
  #5  
Old 06-27-2014, 12:49 AM
khawar khawar is offline Multiple projects in a sheet Windows XP Multiple projects in a sheet Office 2007
Novice
Multiple projects in a sheet
 
Join Date: Jun 2014
Posts: 5
khawar is on a distinguished road
Default

when I go to Tools, Options, Calculation, then the option for 'show multiple critical paths' not available there
Reply With Quote
  #6  
Old 06-27-2014, 06:06 AM
JulieS JulieS is offline Multiple projects in a sheet Windows 7 64bit Multiple projects in a sheet Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Sorry, that was from memory. The command is "Calculate multiple critical paths"
Attached Images
File Type: png Calculate.png (50.3 KB, 30 views)
Reply With Quote
  #7  
Old 06-28-2014, 03:55 AM
khawar khawar is offline Multiple projects in a sheet Windows XP Multiple projects in a sheet Office 2007
Novice
Multiple projects in a sheet
 
Join Date: Jun 2014
Posts: 5
khawar is on a distinguished road
Default

Thanks, now I got the point
My next question is how to link the tasks of different projcets
Reply With Quote
  #8  
Old 06-28-2014, 06:24 AM
JulieS JulieS is offline Multiple projects in a sheet Windows 7 64bit Multiple projects in a sheet Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Create a master project:

http://office.microsoft.com/en-us/pr...001226035.aspx

http://office.microsoft.com/en-us/pr...in=HA001226035

Once you have inserted the subprojects, make sure you have expanded all tasks to see all levels of tasks in the inserted projects. Select the first task (predecessor) CTRL + Click to select the successor task. Click the Link Task button.
Reply With Quote
  #9  
Old 09-30-2014, 04:48 PM
mass588 mass588 is offline Multiple projects in a sheet Windows XP Multiple projects in a sheet Office 2007
Novice
 
Join Date: Sep 2014
Posts: 1
mass588 is on a distinguished road
Default Break link from Resource Pool when project complete

Hello all!

When using a resource pool is there any easy way of automatically breaking the link to projects that have become are 100% complete? Or at least is there an easier way than going to the share list and hunting down the file you want to break the link with?

Thanks,
Max
Reply With Quote
  #10  
Old 09-30-2014, 05:33 PM
JulieS JulieS is offline Multiple projects in a sheet Windows 7 64bit Multiple projects in a sheet Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

No, sorry. You'll need to break the link manually. Open the pool file (read/write) and the sharer file. In the sharer, choose to "Use own resources". Save and sharer and pool. Double check the pool to make sure it has also broken the link.
Reply With Quote
  #11  
Old 03-10-2015, 02:29 AM
khawar khawar is offline Multiple projects in a sheet Windows XP Multiple projects in a sheet Office 2007
Novice
Multiple projects in a sheet
 
Join Date: Jun 2014
Posts: 5
khawar is on a distinguished road
Default

how to see working of all resources on a day
Reply With Quote
  #12  
Old 03-10-2015, 05:45 AM
JulieS JulieS is offline Multiple projects in a sheet Windows 7 64bit Multiple projects in a sheet Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

I'm sorry, I don't understand your question.

If you've created the master project, any task view (Gantt chart, Task Usage view) shows the schedule and who is working.

The resource usage view shows the assignments by resource.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple projects in a sheet Need help in automating data from multiple sheets into a single sheet veedee Excel 1 06-11-2014 04:01 AM
How to print multiple pages per sheet without inner margins? csongi12xme Word 1 02-08-2014 11:51 PM
Multiple projects in a sheet Multiple projects on a single calender Rstaines Project 2 10-03-2013 06:20 AM
Multiple projects in a sheet Multiple Projects - Same Tasks JudithJubilee Project 1 05-20-2013 01:47 PM
Tracking multiple, duplicate projects sundance1 Project 3 01-16-2013 12:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:33 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