Common Spreadsheet Linking Problems
Running an analysis with a linked spreadsheet requires that three software packages (your OS, DPL, Excel) work together. The process works best if all three can "concentrate" on just the analysis. Try to minimize the number of other applications running and avoid CPU intensive activities while a run is in progress.
It's best to minimize Excel so that time isn't spent updating the screen. You can Disable Excel screen updating during run via the Links tab of the Model Settings dialog. Also, don't have any unnecessary files open in Excel. When DPL sends a calculate command to Excel, all workbooks in memory are recalculated (there is no Excel command to calculate one workbook -- it's either one worksheet or all workbooks, and most modern Excel models have multiple worksheets).
Most errors that occur during a spreadsheet-linked run have the following form:
- Error type and context
- Name of the remote application
- Error requesting value from Excel (unexpected return type)
- Application: EXCEL
- Topic: [MySpreadsheet.xls]DCF
- Item: NPV
There is a maximum amount of time DPL will wait for a response from Excel. This parameter defaults to 20 seconds and can be changed within the Links tab of the Model Settings dialog. If DPL needs to start Excel and load the spreadsheet file over a slow network connection, the operation can easily time out. You can increase the timeout parameter, or you can simply load the Excel file before starting the run.
Versions: DPL Professional, DPL Enterprise, DPL Portfolio
Building a Model from a Spreadsheet