Currently our application does not allow you to link a non-financial row to an excel spreadsheet. The rational for this is that linking would be used only when advanced computations were required, and consequently we assumed that any intermediary steps would be calculated within the Excel spreadsheet. It has come to our attention that some of our users would greatly appreciate this functionality, and for that reason it has been earmarked as a future enhancement item.
Until then here is a work around that may be helpful. If you have yet to read our About Modeling Sample post, get started by doing so. Next, save and open the attached company file and review the analysis it contains to see the work-around allowing you to link a Non-Financial Data row to Excel.
Open the analysis and the excel spreadsheet. The analysis rows are not actually linked to the excel file, as the links would be corrupted when the files are transfered and saved to your desktop. However you will notice that the rows in the excel file have identically named rowed in the analysis, assume these are the linked rows.
This sample is based of a real situation where a customer had 50 analyses. Within each analysis they wanted to create a non-financial row that they would link to a set of rates contained within a single excel file. This approach would save lot of time as they would only need to maintain their rates in one Excel file, as opposed to 50 analyses. Start off by reviewing the category comments created on the Statement of Revenues and Expenses, then move to the "Rate" row on the Non-Financial Data tab.