Page 1 of 1
Importing Risk REgister from Excel
Posted: Sat Oct 15, 2011 4:09 pm
by Ken
Is it possible to compile all the data for the risk register in excel and
then import it into Risky Project?
Re: Importing Risk REgister from Excel
Posted: Tue Nov 01, 2011 9:24 am
by Intaver Support
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
Re: Importing Risk REgister from Excel
Posted: Tue Sep 11, 2012 5:14 pm
by Intaver Support
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.