LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Linking MS Project Data into Excel Worksheet

Would like to set up a worksheet that is linked to an MS Project project.
The intent is to pull certain fields from the project and use Excel to
analyze the data and display a stoplight display based upon the results of
the analysis. I can understand how to do the analysis and displaying the
results, but I can't figure out how to link the data input to an MS Project
2003 project plan, so that when I make changes to the MS Project project, it
automatically modifies the spreadsheet the next time I open up the
spreadsheet.
I haven't been able to find anything that tells me if this is possible or
not. Does anyone have a solution?
--
Joseph Stillwaggon
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking worksheet data jra1031 Excel Worksheet Functions 4 March 1st 08 09:53 PM
Linking a cell in MS Excel 2K3 to Ms Project date field MrSilque Excel Discussion (Misc queries) 0 February 21st 07 02:31 PM
Linking MS Project fields in Excel TamiFrank Excel Discussion (Misc queries) 0 November 9th 06 12:23 AM
can I name an excel worksheet tab by linking to worksheet data? jasarussell Excel Worksheet Functions 2 April 12th 06 11:34 AM
Linking to Excel from MS Project Priyanka Excel Discussion (Misc queries) 0 December 15th 04 05:19 PM


All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"