Link Project data into Excel Worksheet

[Neil]

I want to link a value from MS Project file into a cell in an Excel sheet -
can't remember how to do it. I need for the sheet to keep itself updated with
changes made within a project file(s).

 

[Rod Gill]

You can do a copy in Project then an Edit, paste special in Excel. Warning.
Once done don't rename, move or over-write either file or you could corrupt
one or both. If you need to, then break the link by over-writing the pasted
cell (with both files open) then saving BOTH files.

 

[Neil]

Thanks Rod - when I do this, the value that ends up being pasted is a text
value. I am trying to paste a "number of hours" value, so it has the "h" on
the end of the number, and Excel does not recognize it as a number. I need it
to be a number so that I can manipulate it and chart from it. Any ideas?

Neil

 

[Mike Glen]

Hi Neil,

Welcome to this Microsoft Project newsgroup

You might like to see FAQ Item: 10 Exporting to Excel.

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

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

Mike Glen
Project MVP

 

[Bill]

The FAQ link is not working!!

Hi Neil,

Welcome to this Microsoft Project newsgroup

You might like to see FAQ Item: 10 Exporting to Excel.

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

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

Mike Glen
Project MVP

 

[Mike Glen]

Well... it takes you to the Home page, then select the FAQ button.

Mike Glen
Project MVP

 

[Rod Gill]

You'll need another cell that converts the 20h or whatever into a value then
format that cell with custom format 0\h

use formula:
=VALUE(LEFT(A1,LEN(1)-1))

 

[Neil]

This is excellent - exactly what I needed - Thanks Rod!

Neil