Restoring Project Center Stoplights after Exporting to Excel

[William Hogg]

Hi,

This is an FYI post. A number of times I have been asked by clients how
to export the Project Center view containing stoplight indicators to
Excel and still have the stoplight images appear in the exported
spreadsheet.

However, the way the export function works now, if you use stoplights in
your Project Center view, only the values of these fields are exported
to Excel, not the stoplight images themselves.

If you've ever had clients ask about this problem, I've put together a
small tutorial about how to restore the stoplights on an Excel
spreadsheet after exporting a view from Project Center.

It is located at:
http://www.projectservertips.com/Restore_Stoplights_On_Spreadsheets.htm

I hope this is helpful.

William Hogg
www.ProjectServerTips.com

 

[mark.everett]

William,

Thanks for posting. I have bookmarked your site - I think it's
excellent!

Mark S. Everett | PMP
www.quantumpm.com

 

[William Hogg]

William,

Thanks for posting. I have bookmarked your site - I think it's
excellent!

Mark S. Everett | PMP
www.quantumpm.com

Thanks, Mark. I have learned a great deal from Brian Kennemer and the
QuantumPM webcasts, so I'm actually the grateful person.

William