link excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Project Training and help » Link to Excel

Link to Excel

resolvedResolved · Low Priority · Version 2003

Danielle has attended:
Project Intro Intermediate course

Link to Excel

How do I link information in an excel cell to Project?

RE: Link to Excel

Hello Danielle,

Hope you enjoyed your Microsoft Project course with Best STL.
Thank you for your question regarding linking information in an excel cell to Project. You can insert a hyperlink into the excel cell by right-clicking the cell in question, click the Hyperlink button... choose the Existing File or Web Page link to option then, select the Project file from the Look in Area. You will probably have to find the folder first in which the Project file is stored.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Thu 16 Sep 2010: Automatically marked as resolved.


 

MS Project tip:

Keep constraining dates to a minimum

As far as possible avoid fixing the dates of your tasks. For example try to steer of clear dragging task bars in the Gantt chart to move them on the timeline or entering dates directly into the Start / Finish fields.

Date constraints such as these limit Microsoft Project's ability to automatically adjust your project whenever you add, remove or modify the duration of your tasks. Instead use the logic in your task dependencies that link your tasks to enable Project to calculate the start and finish dates for you.

View all MS Project hints and tips


Server loaded in 0.08 secs.