Microsoft Office Forums


Reply
Thread Tools Display Modes

Link Project to Excel and Vice Versa

 
 
Scheduling Analyst
Guest
Posts: n/a
 
      08-16-2006, 04:37 PM
I would like to set up a system that all of my excel files are based off of a
project files cells, for an automatic update purpose, to save time. Is there
a way, either directly or indirectly, to link project cells to excel cells.
MS Excel has a similar feature where you can ( = ) one cell to the next for
update purpose. Microsoft should make some kind of compatibility between the
two to make it more user friendly for the everyday user.
 
Reply With Quote
 
 
 
 
Mike Glen
Guest
Posts: n/a
 
      08-16-2006, 04:45 PM
Hi ,

Welcome to this Microsoft Project newsgroup

They do You can select a cell in Project, copy it and in Excel use Paste
Special - see FAQ Item: 10 Exporting to Excel. Be warned, however, the
links are not robust and any changes in thinsgs, like where the files are
stored, can break links and cause problems.

FAQs, companion products and other useful Project information can be seen at
this web address:http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on :-)

Mike Glen
Project MVP


FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

Scheduling Analyst wrote:
> I would like to set up a system that all of my excel files are based
> off of a project files cells, for an automatic update purpose, to
> save time. Is there a way, either directly or indirectly, to link
> project cells to excel cells. MS Excel has a similar feature where
> you can ( = ) one cell to the next for update purpose. Microsoft
> should make some kind of compatibility between the two to make it
> more user friendly for the everyday user.




 
Reply With Quote
 
 
 
 
Jack Dahlgren
Guest
Posts: n/a
 
      08-16-2006, 07:58 PM
This function exists already. Select the information you want to link. From
edit menu select copy. Switch to excel, select the cell you want to paste to.
From edit menu select "paste special" and in the dialog box check the "paste
link" box.

This method has some issues. Be careful to maintain file names and locations.

-Jack Dahlgren
http://zo-d.com/blog

"Scheduling Analyst" wrote:

> I would like to set up a system that all of my excel files are based off of a
> project files cells, for an automatic update purpose, to save time. Is there
> a way, either directly or indirectly, to link project cells to excel cells.
> MS Excel has a similar feature where you can ( = ) one cell to the next for
> update purpose. Microsoft should make some kind of compatibility between the
> two to make it more user friendly for the everyday user.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Project to Excel and Vice versa: is possible?? Vit Project Developer 2 08-21-2008 06:16 PM
Re: Can I import data from MS Project into Excel or vice-versa? Chip Pearson Excel Misc 1 12-31-2006 03:36 AM
can I link a cell in Excel to a task in Outlook and vice versa Lori Microsoft Office Misc. 0 07-31-2006 10:00 PM
MS Project Server 2002 and Project Professional 2003 & vice versa I-Ali Project Server 2 09-20-2005 07:56 PM


All times are GMT. The time now is 04:32 AM.
Microsoft Office Forums is not affiliated with Microsoft Corporation.


Welcome!
Welcome to the Microsoft Office Forums
 


Latest Threads
Mail Merging Content With High Quality
oleander (04-17-2014, 11:59 PM)

Aargh. What is this?
PeteJ (04-17-2014, 12:10 PM)

Word 2013 Insert Symbol (Not Responding)
tpthrshr (04-17-2014, 02:49 AM)

Can't save a large Word document
Josh (04-17-2014, 01:03 AM)

Remote help?
newman200 (04-13-2014, 12:54 PM)