Importing Risk REgister from Excel

General discussion and questions about project risk management and risk analysis software RiskyProject. Includes discussion on how to perform efficient project risk analysis using our software.

Moderator: Intaver Support

Post Reply
Ken
Posts: 51
Joined: Wed Nov 09, 2005 9:47 am
Location: California

Importing Risk REgister from Excel

Post by Ken » Sat Oct 15, 2011 4:09 pm

Is it possible to compile all the data for the risk register in excel and
then import it into Risky Project?
Ken the PM

Intaver Support
Posts: 823
Joined: Wed Nov 09, 2005 9:55 am

Re: Importing Risk REgister from Excel

Post by Intaver Support » Tue Nov 01, 2011 9:24 am

Ken,

Currently, the our direct integration with Excel is limited to the Chance and Outcome fields in the Risk Assignment. You can cut and paste from Excel but that is the extent of the current capability.

Intaver Support
Intaver Support Team
Intaver Institute Inc.
Home of Project Risk Management and Project Risk Analysis software RiskyProject
www.intaver.com

Intaver Support
Posts: 823
Joined: Wed Nov 09, 2005 9:55 am

Re: Importing Risk REgister from Excel

Post by Intaver Support » Tue Sep 11, 2012 5:14 pm

RiskyProject 4.2 and 5.0 have option to link risk probability and outcomes to Excel spreadsheet. You can use this, to link the chances and outcomes of a particular risk to cells in an Excel spreadsheet. If you link chance and outcomes to an Excel spreadsheet and then make changes to that spreadsheet, RiskyProject will automatically update these values when you open the linked RiskyProject file and click the Refresh Data (Tools tab) button.

To setup integration between RiskyProject and Excel:
1. Setup a connection to an Excel spreadsheet. To setup a connection to Excel spreadsheet on Tools tab click on Connect/Disconnect button. You can visualize the Excel spreadsheet the Visualize Excel button.
2. Open any view in which you can perform risk assignment. For example, the Risk tab of the Task Information dialog box.
3. Right-click on an outcome or chance field. Select Link to Excel Cell from the shortcut menu.
4. The Excel spreadsheet will open. Select a cell within the spreadsheet. In the dialog box, click the button to link the selected cell to an outcome or chance field.
Intaver Support Team
Intaver Institute Inc.
Home of Project Risk Management and Project Risk Analysis software RiskyProject
www.intaver.com

Post Reply