98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Project Training and help » Excell
Excell
Resolved · Low Priority · Version 2007
Robert has attended:
Project Intermediate course
Excell
Would like to live link to excell to produce cumulative cash flowe forecasts
RE: Excell
Hi Robert
Thank you for your question
You can live link data from Project to Excel using copy and paste special. Simply:-
1.Select the data that you want to copy, in this case cost information for your various tasks.
2. Copy the data
3. Open your workbook, and click on Edit-Paste Special
4. Select "Paste Link" and then click OK
This will create a live link to the spreadsheet and when the cost data in project changes, so the worksheet will automatically update. You can then use this data as the basis for your cumulative cash flow
Hope this is useful. if you have any further queries, please do not hesitate to contact me
Regards
Stephen
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Create own ribbon tab - Project 2010a. In Project click on the File tab |