Loading...
Quick Links

Reply To: MS Project Standard 2019 – Linking MS Excel to MS Project

Home Forums Discussion MS Project Standard 2019 – Linking MS Excel to MS Project Reply To: MS Project Standard 2019 – Linking MS Excel to MS Project

#417294
Sai PrasadSai Prasad
Participant
  • Community Leader
  • Forum Pro

Linking % complete field to a spreadsheet is not possible in Project. Alternatively, you need to use custom fields and macro to solve this requirement. First, in the custom fields (text1, text2, ..) have the file location of the spreadsheet and the cell range or address that has test results of each equipment. Second, write a macro to calculate the overall progress for each equipment by using the details of the custom fields and updates the % complete field.